dmacmillan
Board Regular
- Joined
- Apr 5, 2004
- Messages
- 125
Hi All,
My file is referencing data from a number of sheets each across 70 columns.
How would I use find/replace that references the sheet but is agnostic on column?
E.g. Range from column A to Z.
FIND Sheet1![column]200
REPLACE 'Sheet1![column]250
Welcome any assistance.
Kind regards,
David
My file is referencing data from a number of sheets each across 70 columns.
How would I use find/replace that references the sheet but is agnostic on column?
E.g. Range from column A to Z.
FIND Sheet1![column]200
REPLACE 'Sheet1![column]250
Welcome any assistance.
Kind regards,
David