OverhandLeft
New Member
- Joined
- Sep 1, 2008
- Messages
- 9
Hello,
I have a macro that results in an ouput file of an excel spreadsheet.
There is a named range in the macro the clears data in the assigned range.
Let's say the range name is CLEAR_DATA with the range being
='Sheet2'!EG$78:EG$85,'Sheet2'!EG$92:EG$94
For some reason, when I run the macro to get the output file,
data is cleared from A78:A85 and A92:A94
Then I check the output file's range for CLEAR_DATA and I get
='Sheet2'!A$78:A$85,'Sheet2'!A$92:A$94
Would anyone happen to know what would cause this or how to
fix it?
As always, Thanks in advance to anyone that could help.
I have a macro that results in an ouput file of an excel spreadsheet.
There is a named range in the macro the clears data in the assigned range.
Let's say the range name is CLEAR_DATA with the range being
='Sheet2'!EG$78:EG$85,'Sheet2'!EG$92:EG$94
For some reason, when I run the macro to get the output file,
data is cleared from A78:A85 and A92:A94
Then I check the output file's range for CLEAR_DATA and I get
='Sheet2'!A$78:A$85,'Sheet2'!A$92:A$94
Would anyone happen to know what would cause this or how to
fix it?
As always, Thanks in advance to anyone that could help.