Get instant live expert help on I need help with for each cell in range vba

“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

trying to run a recorded macro for each cell in a range. the macro works but it will not go through each cell in the range - however it does apply the macro to the currently selected cell
Solved by E. Q. in 21 mins
VBA HELP: For Each Next or Loop addition to my code: I have a variable, named C, that's referencing a cell value. After running the code, I want that reference to move down 1 row, select that new cell value, place it into my C variable and run macro again. Repeat until all values in range have been completed.
Solved by T. S. in 26 mins
need VBA to save WB as range E6 Its a button in that worksheet that gets saved as cell E6. I already have VBA code that works but wont save the wb in the correct folder?
Solved by S. Y. in 18 mins
Hello, I would like to select the range below my cell that has bold font. Right now I have this code. Sub Findandcut() Dim rngA As Range Dim cell As Range Set rngA = Sheets("Sheet1").Range("d2:d9") For Each cell In rngA If cell.Font.Bold Then cell.Offset(1, 0).Select End If Next cell End Sub --- But I would like to select each of the ranges below each of the cells that have bold fonts. In my column I have 5 cells with bold fonts
Solved by E. H. in 16 mins
We have a lottery bingo sheet where each entrant picks 6 numbers and when they come out in the lottery they get highlighted in grey. At the moment I am having to go through each individual line/cell to highlight manually. I would like to create a formula/macro/vba to automatically highlight a cell if the value in it is in the range of data where I put the lottery numbers. I have had it done for me in the past but it was by a customer who no longer comes in to the pub, but 'm sure he used a macro/vba. Cheers
Solved by D. D. in 16 mins