| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell to worksheet
I have two open worksheets. The VBA would copy data from the source
worksheet then paste that information to the target worksheet. The exact target worksheet name is always in cell c7 of the source worksheet. So, based on that value, it first locates the same sheet number in the target Worksheet, then pastes the data. The source worksheet (tab) name keeps changing and does not always match precisely the name in cell c7 of that sheet (which does not change) -- douglass |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to worksheet
Use the worksheet codename and remove link to c7 if it never changes. If
also makes the copy operation simpler by referring to the sheet by its codename. e.g Sheets("MyTarget").Range("A1") = MyCodeName.Range("A1") -- Regards, Nigel "douglass" wrote in message ... I have two open worksheets. The VBA would copy data from the source worksheet then paste that information to the target worksheet. The exact target worksheet name is always in cell c7 of the source worksheet. So, based on that value, it first locates the same sheet number in the target Worksheet, then pastes the data. The source worksheet (tab) name keeps changing and does not always match precisely the name in cell c7 of that sheet (which does not change) -- douglass |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| link a cell in the 'Master' worksheet list to a 'Detail' worksheet | Excel Programming | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| selecting cell range in other worksheet without switching to worksheet | Excel Programming | |||
Linear Mode
