Find row/cell reference with Macro

Hi

I have a table that looks like this

A
B
C
D
Grand Total
0
0
0
0
0
0

I want to find which row Grand Total is at or the Cell reference of "Grand Total"

I recorded a macro in which I used the "Find" function to find the "Grand Total" cell (as shown below) but do I make it return the cell reference instead of just activate the cell?

Please Login or Register  to view this content.

Thank you.

Please Login or Register  to view this content.

Thanks. I just realized that there is more than one "Grand Total" cell in the sheet, I thought there was only one.

So I need to find "Grand Total" in Column E. I see you devise a message box to display the address. How I extract the row number of the address and use it in Macro.

What I will do next is to move the "Grand Total" row of the report (from Column E to Column K) to the row below using the following code:

Please Login or Register  to view this content.

LastRow would be the row number of "Grand Total".

Thank you.

Please Login or Register  to view this content.

Thank you.

I want to delete all the rows below "Grand Total" row using the following code

Please Login or Register  to view this content.

Could you help me state the first line of code in the correct format?

You are welcome.

Please Login or Register  to view this content.

Or this if you want to really "delete" the rows.

Please Login or Register  to view this content.

Hi millz

VBA says there is a bug in the code and highlighted this part in yellow:

Please Login or Register  to view this content.

Originally Posted by kanonathena

VBA says there is a bug in the code and highlighted this part in yellow

Sorry about that, remove the "After:=ActiveCell, ".

Please Login or Register  to view this content.

Please Login or Register  to view this content.