Row and Column Returns

[Gtea]

Hello, I am fairly new at this so here goes.

I am trying to return string from a dynamic row but static column to a single cell on running the macro.

I have been able to get the macro to return my dynamic row with ActiveCell.Row

and then tie up the result to a cell in excel.

What I cannot do is get the fixed column to register and then combine the 2 to give me whats in the cell at that reference.

so far I have,

Please Login or Register  to view this content.

This gives me the row number.


can anyone help.

Thanks Gtea

[Leith Ross]

Hello Gtea,

If you want the column number of the ActiveCell then follow the same logic as the row number. Use the Cells property to givve you the reference you want.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Gtea]

excellent!

It works great. I was going for the fixed column so thanks for that.

I had the right idea but did not know the Cells(R, C).Value function. I was using to Dims for R & C and trying to use the Union function to come up with a range for the search. Was not working. So thanks again.

Gtea