Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everybody
I´ve just pasted the following macro and run it within my worksheet, but an error displays as I have merged cells. Should I consider some additional sentence for that?? (I don't know how works VBA). Sub rob() For each r in activesheet.range("C7:h29").cells if r.locked then else r.clearcontents end if Next End sub Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to clear contents of certain cells | Excel Discussion (Misc queries) | |||
clear unlocked cells macro help please | Excel Worksheet Functions | |||
Delete contents unlocked cells | Excel Discussion (Misc queries) | |||
Macro to clear contents of unprotected cells AND drop down boxes | Excel Discussion (Misc queries) | |||
Selecting only unlocked cells to clear | Excel Programming |