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

“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

Excel VBA not incrementing the value of a specific cell. Function SayIt(cell1 As Variant, Optional baSync As Boolean, Optional bPurge As Boolean) ThisWorkbook.Worksheets("Latest").Activate Dim Roll As Integer, result2 As String Roll = ThisWorkbook.Worksheets("Latest").Range("d2").Value ' The value of cell D1 is currently 1 MsgBox "Sayit Before ROLL " & Roll Roll = Roll + 1 MsgBox "Sayit After ROLL " & Roll End Function
Solved by A. U. in 20 mins
I need assistant with an excel formula maybe some variant of the count formula to assist in counting the number of invoices numbers that are not the same.
Solved by S. J. in 25 mins
I have two tables (tabs) in a google doc, I need help looking up the SKUs from Sheet1and returning the data for SKUs in Sheet2. I need the data from the following columns Published, Variant SKU, and Variant Inventory Qty.
Solved by A. L. in 11 mins
hi i am looking for vba expert . i need to modify an vba excel file.
Solved by X. E. in 21 mins
Hi, I am trying to generate an email from an excel where part of the body is taken from a list on the sheet and has words added next to it. i.e the list contanins apples,oranges,pears and i want the email body to say option1 apples option2 oranges etc. this is my code for that but it doesnt seem to work Dim leg() As Variant leg() = Range(FirstRange, LastRange).Value Dim a As Variant For a = FirstRange To LastRange leg(a) = "Leg" & "[" & a & "]" Next a
Solved by K. H. in 14 mins