Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky copy/paste question
I want to copy and paste a few rows within the current worksheet. Many cells in those rows have formulas, some of which reference cells within the current sheet while others reference cells from other worksheets. Here's the logic I want to build in my macro - any formula that references cells from another worksheet, paste it without changing relative references. Paste all other formulas and change the relative reference. Please help me develop a good way to do this. Thx -- cooldyood ------------------------------------------------------------------------ cooldyood's Profile: http://www.excelforum.com/member.php...o&userid=35611 View this thread: http://www.excelforum.com/showthread...hreadid=570512 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question, Copy-Paste | Excel Discussion (Misc queries) | |||
Copy and Paste Question | Excel Discussion (Misc queries) | |||
Copy/Paste Question | Excel Discussion (Misc queries) | |||
Copy/Paste question | Excel Worksheet Functions | |||
Copy Paste Question | Excel Discussion (Misc queries) |