vba - Error involving ADO recordset and excel worksheet name -

i attempting execute following code:

rs.open "select * [step#2-presource$f3:f15]", cnn, _             adopenstatic, adlockoptimistic, adcmdtext 

i receive error:

notice in error notification converts # sign period. there in fact no existing object such name. not intended. there way work around issue of sort?