| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass worksheet to macro as a parameter
Hi, I've got following situation. I'm trying to create a command bar,
which help other users make calculation Things are working fine, almost. With my macro user can open txt file, macro is making some changes in format, adding columns, formulas, sorting etc. At the end I want to remove unnecessary rows (with non numeric and empty cells in column A), when I give fixed name of the sheet it works well. But how to pass the opened sheet name to this macro, to make changes on that? TIA Przemek |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pass worksheet to macro as a parameter
activesheet.name
-- HTH... Jim Thomlinson "Przemek" wrote: Hi, I've got following situation. I'm trying to create a command bar, which help other users make calculation Things are working fine, almost. With my macro user can open txt file, macro is making some changes in format, adding columns, formulas, sorting etc. At the end I want to remove unnecessary rows (with non numeric and empty cells in column A), when I give fixed name of the sheet it works well. But how to pass the opened sheet name to this macro, to make changes on that? TIA Przemek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pass parameter to access query | Links and Linking in Excel | |||
| Pass date parameter into MS Query | Excel Discussion (Misc queries) | |||
| Is it possible to pass a parameter into IN operator in Query? | Excel Discussion (Misc queries) | |||
| Application.OnTime -- Unable to Pass Macro with Numeric Parameter | Excel Programming | |||
| Pass Parameter to Access Query | Excel Programming | |||
Linear Mode
