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