Hi there
I am new to VBA on excel. Can someone help please.![Cry :cry: :cry:](/styles/default/custom/smilies/cry.gif)
I have a spreadsheet of many columns and rows. I need to find the word "Record Id" (which is normally in column A somewhere) and then delete 10 lines from where the Record ID word is.
Right now I have to do it manually by searching Ctrl + f and then selecting 10 lines and deleting. But if I can have a code, it will be much faster.
Thanks
I am new to VBA on excel. Can someone help please.
![Cry :cry: :cry:](/styles/default/custom/smilies/cry.gif)
I have a spreadsheet of many columns and rows. I need to find the word "Record Id" (which is normally in column A somewhere) and then delete 10 lines from where the Record ID word is.
Right now I have to do it manually by searching Ctrl + f and then selecting 10 lines and deleting. But if I can have a code, it will be much faster.
Thanks