A
alienscript
Hi,
I am looking for help with a code that is able to cut or delete al
rows that has any cell values strikethrough in any column in th
currently open worksheet, and paste those rows in the blank Sheet2 fro
row 2 downwards. Sheet2 must also have the Header names being copie
over to Row 1.
The open worksheet has cells strikethrough in all the characters, no
just some characters.
After the rows have been removed, the open worksheet should
not contain blank rows in between. The Header names in row 1 must be i
tact.
Any suggestions is much appreciated.
Thanks in advance
I am looking for help with a code that is able to cut or delete al
rows that has any cell values strikethrough in any column in th
currently open worksheet, and paste those rows in the blank Sheet2 fro
row 2 downwards. Sheet2 must also have the Header names being copie
over to Row 1.
The open worksheet has cells strikethrough in all the characters, no
just some characters.
After the rows have been removed, the open worksheet should
not contain blank rows in between. The Header names in row 1 must be i
tact.
Any suggestions is much appreciated.
Thanks in advance