| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet reference in VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| multiple cell reference from sheet to sheet | Excel Worksheet Functions | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Threaded Mode
