Pass worksheet to macro as a parameter

  • Thread starter Thread starter Przemek
  • Start date Start date
P

Przemek

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass a worksheet as a parameter to a function? 5
Refer in macro to cell 1
How can I enable a macro to run in a hidden worksheet? 2
Macro to combine worksheets 10
Passing worksheet as an argument 3
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Sort column without referencing sheet name 4
Macro for all Excel Workbooks to print to PDF 2

Back
Top