Posted to microsoft.public.excel.programming

Brad[_26_] Brad[_26_] is offline

external usenet poster

Posts: 10

Including tab name in absolute reference

I have lots of spreadsheets that have the same seven tabs in them. How do I
automatically ensure that the correct tab is selected when running a macro
with absolute references? Is there a way to have the macro select the tab
before running the rest of the macro?

Brad

Excel 2002 on XP Pro SP 3
Excel 2007 on Vista 64

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Absolute cell reference will not remain absolute.	Mike K	Excel Worksheet Functions	1	October 8th 08 07:12 PM
How can I do an Absolute Cell Reference but non Absolute Cell Pais	John	Excel Programming	1	July 22nd 05 07:28 PM
How can I do an Absolute Cell Reference but non Absolute Cell Pais	John	Excel Programming	0	July 22nd 05 06:23 PM
Creating absolute references including active sheet name in the formula	Maria J-son	Excel Programming	4	May 10th 05 08:41 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us