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!”
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