Multiply range of cells by set value

[jg135]

Hello-
I'm trying to multiply a range of cells by a specific value with the result populating in the next column. I need the code to only calculate the formula if there is a number in my range (I have blank cells & cells with text that I don't want messed up). Ex. If A1 has a value, then multiply by .66 and input result in B1.

I can have the value that each cell needs to be multiplied by in another cell or the value just in a formula. I have found many similar posts on this problem but can't seem to get the solutions to work 100% correctly for me. I'm very new to code/VBA/macros and am trying to self-teach myself- it's going great, clearly

Thank you in advance!!!!

[davesexcel]

Would you not just use a formula?

Please Login or Register  to view this content.

[jg135]

Are you asking about just using a formula instead of code? Or using that formula in a code? I can't just use a formula because if I paste it in my report it will erase my headers. My full report has over a hundred sections & I need to compute each one.
Attachment 826920
If you are referring to using that formula in a code- how would I incorporate that into a full code to pull the right range, loop & input cell?

[TMS]

Why don't you just delete all the mid-flight headings, close up all the blank rows, and use Sub-totals (based on a change in column A) to get your total lines?

That would take the edge off the VBA learning curve.

[davesexcel]

Try this

Please Login or Register  to view this content.

[jg135]

That worked!!! Thank you so much!!! I might be pushing it with this - is there anyway to have the formula show in the cell vs just the value? Not a requirement- just curious.

[TMS]

Maybe this:

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

Test Out the below codes, one selects numbers only and the other selects text only.

Please Login or Register  to view this content.