Storing Row with VBA

[Carl Clements]

Hi,

I have some code that inserts a new row to a spreadsheet when it find the first row without data in column A. Is there some code that then stores the row number it's on? i suppose it would be something like StoreRow = ActiveRow.Address

I then need some code that allows me to move down the required number of rows from a fixed cell to arrive at the stored row. Is there some code for this also?

Thanks,
Carl

 

[VoG]

Try

StoreRow = ActiveCell.Row

 

[Carl Clements]

Thanks. And what is the code to move down from the row with active cell to the stored row?

I need to get from cell E9 to D14 (Row 14 is the stored row). E9 (or row 9) will be constant but the stored row number will be different each day, ie it will be D15 the next day.

 

[VoG]

Try

Range("D" & StoredRow).Select

 

[Carl Clements]

Thanks. However, only only Row 9 will be constant, not cell E9. The column can change. I have stored the cell variable as StoreLocation

So I tried the below but it takes me to Row 914 for some random reason

Range(StoreLocation & NewRow).Select

Any suggestions?

 

[Jenny_Genesis]

Hey,
How to store only alt-rows..

Best regards,
Jenny_Genesis

 

[Carl Clements]

Not sure what the last reply means but I need some code that can store the column. I believe it needs to convert the column letter into a number somehow?

 

[VoG]

Like this?

StoreCol=ActiveCell.Column

You can then get back using

Cells(StoreRow, StoreCol).Select