Hi, I'm new to macros. I want the macro to activate with one of the choices of a drop down list. I want the macro to clear a range of cells. The code I have is:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Select Case Range("M17")
Case "Choice 1"
Range("V18:AC18").Select
Selection.ClearContents
End Select
End Sub
I get run time error 28 Out of stack space.
Could someone let me know what I am doing wrong?? thanks!!
Can you explain a bit more what you want. The above code makes no sense
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
I want a choice from a dropdown list to activate a macro which clears a range of cells...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks