Get instant live expert help on I need help with vba is blank
“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'm trying to take a column of data and make it into a table using VBA or a Macro. There is a blank row between every grouping. Is there a command to make this a table based of that empty cell? VBA/MACRO question
Solved by E. H. in 25 mins
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor. Function Depreciation (Value, Rate) Depreciation = Value * Rate End Function
Solved by F. C. in 11 mins
VBA code help for looping the macro. I need to loop the VBA code which does the following "Whenever the value in cell B2 of sheet1 changes and it is greater than zero, then value is copied and pasted into sheet2 column A in the next blank cell, ie, A2,B2,C2. I need help to change this code to loop through the cells of Column B ie through B2 to B100."
Solved by V. U. in 14 mins
I have a workbook with multiple sheets. In cell e8 on each sheet there is letter "y" or it is blank. i want to creae a summary sheet that will tell me how many E8 cells have "y" in them. I need a formula as i cant use VBA on this book.
Solved by C. J. in 29 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