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