Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a range after selecting a sheet
I have a button on a worksheet that when pressed is supposed to:
1. Go to another worksheet in the same workbook 2. Select a range of cells in that worksheet 3. Delete the selected range of cells However I am getting the following error message: "Select method of Range class failed" when the code executes -- Range(selRange).Select-- Can someone inform me of how I can fix this? Thanks in advance The code segemnt is below ------------------------------------ selEnd = readRow - 1 selRange = "A" + Trim(Str(selBegin)) selRange = selRange + ":" + "F" + Trim(Str(selEnd)) Sheets("Shared Emp Master Sheet").Select Range(selRange).Select <- ERROR OCCURS HERE Selection.Delete Shift:=xlUp ------------------------------------ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a range after selecting a sheet
Hi
Replace Str with Cstr and you need Sheets("Shared Emp Master Sheet").Activate Range(selRange).Select Selection.Delete Shift:=xlUp better still do Sheets("Shared Emp Master Sheet").Range(selRange).Delete Shift:=xlUp regards Paul On Feb 25, 3:27*pm, wrote: *I have a button on a worksheet that when pressed is supposed to: 1. Go to another worksheet in the same workbook 2. Select a range of cells in that worksheet 3. Delete the selected range of cells However I am getting the following error message: "Select method of Range class failed" when the code executes -- Range(selRange).Select-- Can someone inform me of how I can fix this? Thanks in advance The code segemnt is below ------------------------------------ selEnd = readRow - 1 selRange = "A" + Trim(Str(selBegin)) selRange = selRange + ":" + "F" + Trim(Str(selEnd)) Sheets("Shared Emp Master Sheet").Select Range(selRange).Select * * * *<- ERROR OCCURS HERE Selection.Delete Shift:=xlUp ------------------------------------ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More Selecting and Deleting | Excel Programming | |||
Selecting AND Deleting | Excel Discussion (Misc queries) | |||
Selecting and deleting named range based on cell value | Excel Programming | |||
Selecting Range in non-active sheet | Excel Programming | |||
sub for deleting data on a sheet in a range | Excel Programming |