delet columns and rows

  1. F

    With...

    Hi, I want to delete one column. Generaly It could be done like: Columns("AY:AY").Select Selection.Delete Shift:=xlToLeft But how to do it in "With...." With sourceWb.Sheets("Sheet1") .Range("A1:B6").EntireRow.Delete LastRow = .Range("CW65536").End(xlUp).Row '....delete...
  2. A

    Macros need whole line moved to new worksheet automatically

    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> <o:p> </o:p> attempted to create the formula, but...
  3. M

    Need to remove multiple unique groups of numbers

    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...
  4. S

    Delet columns and rows

    dear sir, 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 thanking you shrikant

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top