Chirag Raval
asked on
How to Delete all columns after last cell with data in row 1?
Dear All experts,
I already use this link's Mr Patrick Matthews's suggested code for delete all rows below data provided at this link of this site.
https://www.experts-exchange.com/questions/27255636/Delete-All-Rows-after-Last-Row-with-Data.html
but same question for columns...how to delete all columns after last filled data on row 1.
or how to modify above linked code to delete columns.
Please Help.
Regards,
Chirag Raval
I already use this link's Mr Patrick Matthews's suggested code for delete all rows below data provided at this link of this site.
https://www.experts-exchange.com/questions/27255636/Delete-All-Rows-after-Last-Row-with-Data.html
but same question for columns...how to delete all columns after last filled data on row 1.
or how to modify above linked code to delete columns.
Please Help.
Regards,
Chirag Raval
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Solutions according to author's comment
ASKER
Great, Amazing Both works like a charm..
Thank you very much
Regards,
Chirag Raval