Sheet reference in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

In a macro I use

With Sheets("sht2").Range("b1:b100").AdvancedFilter _

to select a range on a sheet.

I want to select the sheet to perform this operation on by adding the sheet
name to a cell at a different sheet.
Say in the sheet "Sht1" in cell "a1" I put the name "Sht2"

How can I adjust teh code so that it will use at the value in sheet "Sht1"
in cell "a1"?

Best regards, Gijs
 
Thanks it works!

Best regards,

Gijs

Chip Pearson said:
Try

With
Sheets(sheets("Sht1").range("A1").text).Range("b1:b100").AdvancedFilter
_


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


in message
Click to expand...
 
Back
Top