Get instant live expert help on I need help with excel vba clearcontents

“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

I have a vba error. Subscript out of range Sheets("Harvest Data").Range("A2:N10000").ClearContents
Solved by F. Y. in 14 mins
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
hi i am looking for vba expert . i need to modify an vba excel file.
Solved by X. E. in 21 mins
VBA Excel. I have request from my boss to have a button on the VBA Excel Form to print a work order and put the Equipment Name that is on the VBA form in the Work Order (a word doc) and print it.
Solved by F. F. in 26 mins
i need help with VBA is this included and are all operatives experts in VBA and not just excel
Solved by X. Q. in 23 mins