MrExcel Publishing
Your One Stop for Excel Tips & Solutions

useing variables as cell refrences

Posted by randy on September 14, 2001 5:49 AM

this is idea i am working on to shorten my formula..
will this work and how can i get counter1 to change from ae to af to ag etc?

counter1 = ae
counter2 = b7

do until counter2 = b13
Range("SHEET3!$P$1:$AB$500").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"SHEET3!$counter1$1:$counter1$2"), CopyToRange:=Range("SHEET3!$AS$1:$BE$1"), Unique:=False
If Not IsEmpty(Range("INFO!counter2+1")) Then
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End If

Posted by randy on September 14, 2001 5:56 AM

would an offset work? (nt)