Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Although the sheet reference needs to be absolute, the workbook reference is only loosly absolute. The source and destination workbooks change each year, and the macro looks at the workbooks that are currently open in order to determine which ones to use. Thanks though. -- Brassman ------------------------------------------------------------------------ Brassman's Profile: http://www.excelforum.com/member.php...o&userid=13290 View this thread: http://www.excelforum.com/showthread...hreadid=495535 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Absolute Sheet Reference | Excel Worksheet Functions | |||
Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
Reference to sheet name in another workbook | Excel Discussion (Misc queries) | |||
Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
See code enclosed - Convert to formulas with absolute reference inculding the sheet references! | Excel Programming |