| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Row - Select to end of sheet
Hello!
I am trying to create a section of macro to find the first row of data from the bottom of the sheet up, select one row down from the ActiveRow to the end of the sheet, then Clear the content of the selected rows. The row location of the data is always different. I have tried the folowing, but it does not work. I would greatly appreciate help! Range("A65536").End(xlUp).Select ActiveCell.Offset(1, 0).Rows("1:65536").EntireRow.Select Selection.Clear |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternate Row Select in Sheet 1 then Paste to Sheet 2 | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| Use of Sheet CodeNames to Select Sheet in Different Workbook | Excel Programming | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
| Select Sheet then Select Range | Excel Programming | |||
Threaded Mode
