Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the code behind a userform I have tried to clear the contents of some
cells, but I get a 1001 error. With ActiveWorkBook.Sheets(LoadSheet).Range(Cells(RowSe l, "B"), Cells(RowSel_TLA , "BA")) .ClearContents End With The above works from a normal module, but will not run from a worksheet or a userform. If there something else I can do to achieve the same thing? -- Trefor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error when selecting date range. | Excel Programming | |||
Help selecting a range in vba from userform inputs | Excel Programming | |||
User selecting range from userform via dropdown menue | Excel Programming | |||
1004 error when selecting a range | Excel Programming | |||
Error 1004 when selecting a range | Excel Programming |