trying to select a range and then copy it-

[navyaa]

I am trying to select a cells br3 to bs2000 which are on sheets MACROS and then after selecting them, i filter the columns based on a criteria and then finally i need to copy them over.

This is the code i have but there is some problem as it gives an error while selecting the cells...

Sheets("macros").Select
Range(br3, bs2000).Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd
Selection.Copy
ActiveWindow.SmallScroll Down:=-12
Range("BT3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
Range("BR3").Select
Selection.AutoFilter

Please let me know whats wrong with this??
thank you
Navya

 

[Tom Urtis]

One problem is in line 2, which should read
Range("BR3:BS2000").Select

I can see several other areas in your code which will also result in errors eventually, if not immediately. If/when you experience further errors, please post your question on the Excel Questions message board, and not here.

 

[navyaa]

Thank you for your help and sorry for posting the question here.

I didnt realize it as i had just hit the new topic button and posted it here.

I will make sure it wont happen again...