| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Referencing Variable Name Worksheets
I'm updating a formatted worksheet every day. I have a macro that
processes, lets the user augment, and then saves that days data into a new worksheet with that days date. I need to reference that worksheet the next business day to error check. I cannot : PREVIOUS DATE IS IN CELL A1 s = range("a1").value worksheets(s).select Thank you for any help/suggestions Chris Cameron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Referencing multiple workbooks via single variable | Excel Worksheet Functions | |||
| Summary worksheet referencing multiple worksheets | Excel Worksheet Functions | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
