Get instant live expert help on I need help with vba cells value
“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
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
WHAT WILL BE IN CELL B10 AFTER VBA EXECUTES THE ASSIGNMENT? Cells(10,"B").Value = 19\3 + 17 MOD 5
Solved by D. W. in 13 mins
I created a user-defined function (VBA) to make some calcs. Once I got the results, I saved it, then came back to keep working on it and the cells where I used the VBA are showing #VALUE!
Solved by M. S. in 21 mins
VBA Stack Prob " Private Sub Worksheet_Change(ByVal Target As Range) Dim i As Integer For i = 4 To 200 If Cells(i, "J").Value <> "" And Cells(i, "L").Value = "" Then Cells(i, "L").Value = Date & " " & Time Cells(i, "L").NumberFormat = "d/m/yyyy h:mm AM/PM" End If Next Range("L:L").EntireColumn.AutoFit For i = 4 To 200 If Cells(i, "L").NumberFormat <> "" And Cells(i, "L").NumberFormat = "d/m/yyyy h:mm AM/PM" Then Cells(i, "C").Value = "" End If Next Range("C:C").EntireColumn.AutoFit End Sub"
Solved by T. L. in 25 mins
Why does 2013 & 2016 not resolve VBA match. This statement works in 2007 (where I started my code) but always results in 1 for 2013 & 2016. MyHoliday = -1 * IsError((Application.Match(Cells(3, J).Value, Range("HolidayNotEaster").Value, 0))) Naturally HolidayNotEaster is a list of dates and Cells(3, J) is also a date
Solved by Z. W. in 30 mins