I want to delete one column.
Generaly It could be done like:
But how to do it in "With...."
LastRow = .Range("CW65536").End(xlUp).Row
I want to create a macro that when date is inserted into certain cell, have the whole line moved to a new worksheet, and re move from original sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
attempted to create the formula, but...
I am looking for an if then formula that will help me remove groups of data from sheet 1. I added sheet 2 which only has 1 column of unique id's that I want removed from sheet 1. In sheet 1 there could be multple rows that have the id that was found on sheet 2. Does anyone have a formula that...
i most of the time use excel.
i want to know that,
i want to keep columns from A to H and Rows from 1 to 55.
i want to delete rest all columns and rows and it should not generate the columns and rows again and again.
pl, help me