| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
current worksheet
Hi
How do i use VB code to find name of current worksheet. I run same macro from different sheets to copy data to another. I want the code to figure out the current worksheet and make reference to this sheet in a paste area thansk -- Kevin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
current worksheet
Try this
myname = ActiveSheet.Name Mike "Kevin" wrote: Hi How do i use VB code to find name of current worksheet. I run same macro from different sheets to copy data to another. I want the code to figure out the current worksheet and make reference to this sheet in a paste area thansk -- Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I describe the current worksheet? | Excel Worksheet Functions | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| I need current value of one worksheet into another cell? | Excel Worksheet Functions | |||
| Updating different worksheet with value on current worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Linear Mode
