CRUTHERFORD
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 107
Hi,
I have a spreadsheet that is used for data inputting.
1. How can I get VBA to delete all columns to the left of a cell containing the text "Y/N" until "Y/N" is in cell P25?
2. How can I get VBA to absolute reference cell 'S4' so that if another column is added it will follow the position of what was in cell 'S4' that is now in cell 'T4'?
Thanks,
C
I have a spreadsheet that is used for data inputting.
1. How can I get VBA to delete all columns to the left of a cell containing the text "Y/N" until "Y/N" is in cell P25?
2. How can I get VBA to absolute reference cell 'S4' so that if another column is added it will follow the position of what was in cell 'S4' that is now in cell 'T4'?
Thanks,
C