ShelleyBelly
New Member
- Joined
- Mar 2, 2011
- Messages
- 44
Hi All,
I've been importing .xml data into an Excel sheet and I'm now having issues with cell referencing in Formulas as they won't reference the worksheet address but instead the address in the imported .xml table, this is an issue as the table will be frequently be changed and so will void the formula. I essentially need to Convert To Range but I can't Macro Record this. The data is always in the same columns. Cutting and pasting just doesn't cut it
.
Many Thanks in Advance
Tom
I've been importing .xml data into an Excel sheet and I'm now having issues with cell referencing in Formulas as they won't reference the worksheet address but instead the address in the imported .xml table, this is an issue as the table will be frequently be changed and so will void the formula. I essentially need to Convert To Range but I can't Macro Record this. The data is always in the same columns. Cutting and pasting just doesn't cut it
.Many Thanks in Advance
Tom
Last edited:
