brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a macro which steps through each row in column from E3 downwards. If it finds an entry (Text or number or date) in this column I then need a process to run to clear all the contents in that row except for column F which contains a formula. I do not want to delete the row - just clear its contents.
I am not sure if it is easier to clear contents for the entire row as only columns A to G have data in them in the worksheet.
Can anyone help I have looked for a solution but they all seem to delete the row
I am not sure if it is easier to clear contents for the entire row as only columns A to G have data in them in the worksheet.
Can anyone help I have looked for a solution but they all seem to delete the row