LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default vba/macro recognizing other worksheets open

How can I have the macro / vba prompt me for the name of the workbook
and sheet each time I run it? Both the active sheet and the one I
would be pulling from will be open, but the one I am pulling from
will
change in name and its sheet names will be different each time.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro not recognizing .xlsx spreadsheet kevgret Excel Discussion (Misc queries) 8 March 17th 09 04:44 PM
Macro not recognizing blank lines as blank pm Excel Discussion (Misc queries) 9 May 22nd 07 04:16 PM
macro for all open worksheets? barkiny[_5_] Excel Programming 3 December 2nd 05 05:08 PM
Macro to Open and Compile Multiple Worksheets that are password protected MissJen Excel Programming 1 January 3rd 04 03:42 AM
Defining an auto-open macro that prints specific worksheets sam[_3_] Excel Programming 1 November 21st 03 08:52 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"