Get instant live expert help on I need help with excel vba clear range

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi I use the following code to clear the contents of C4 and C12 whenever the value in C2 changes Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C2")) Is Nothing Then Range("C4").ClearContents Range("C12").ClearContents End If End Sub This works fine every time but I now need a similar function to clear the values in C12 when value in C4 is changed. i.e. Change C2 clears C4 & C12 Change C4 clears C12 How should I go about this? Any advice gratefully received. PS, I'm not a VBA programmer (as you can probably tell!) Regards Mike
Solved by G. J. in 16 mins
I want help on Excel VBA, to send a variable range of cells through Excel using Outlook
Solved by A. F. in 12 mins
I have a vba error. Subscript out of range Sheets("Harvest Data").Range("A2:N10000").ClearContents
Solved by F. Y. in 14 mins
In VBA for Excel 2016, I am puzzled why 'Range(Cells(3,6)).Value' gives an error whereas 'Cells(3.6).Value' does not.
Solved by G. D. in 24 mins
Hi I need help creating a macro in Excel VBA. This macro needs to be able to copy a range of cells and paste that range as a picture in an outlook email
Solved by S. J. in 26 mins