Need help with formula for macro

[Julie W]

I am working on a macro and need help creating a formula that will check to see if the next row is blank. If the next row is blank, it needs to stop the macro. if tne next row is not blank, I want to run the following formula (using the next cell and so on until it comes to a blank row).
This is the formula that it needs to run if the row is not blank =RIGHT(A32,LEN(A32)-FIND(" ",A32,1)-2)




Anyone have any ideas?

Thanks in advance !!

 

[General Ledger]

Julie W,

Here is some code I have used to find the number of the last row of data. This code goes to the bottom of column A. Does an end-up to find the last entry in the column.

Dim LastRow As Long
    LastRow = Range("A" & Rows.Count).End(xlUp).Row

Now that you have the number of the last row, you can put your formula inside a Do Loop.

DO UNTIL ActiveCell.Row = LastRow + 1

Best of luck,

G/L