How to make a macro containing a relative cell rather then a specific cell

[Daintel]

Hello

First-time user to this site so I apologise if I appear to be a little clumsy.

I am using Excel 2010 and trying out some macros.

How do I make a macro containing a relative cell rather then a specific cell.

ie: When recording a macro, I wanted the macro to move to the start of the row but got the following code: Range("I32").Select because I was in "I32" when registring the macro. I wanted the macro to go to A32 if I was in row 32 or A33 if I am in row 33 etc...

Looking forward to hearing from one of you.
Best regards
Patrick

 

[Sektor]

What macro do you have and what it does?

 

[Daintel]

Hi thanks for answering so fast.

This is the macro I have registered:


Range("I32").Select
ActiveCell.FormulaR1C1 = "9"
Application.Run "todo4.xlsm!SortByDate"


I would like to change it so that:

Range("I32").Select actually brings the cursor to the start of the row in which my cursor is currently standing.

so that:
ActiveCell.FormulaR1C1 = "9" actually brings the cursor to column "I" on the row in which my cursor is currently standing and enters "9" in the cell

Any suggestion?

 

[Marcelo Branco]

Try this

Rows(ActiveCell.Row).Cells(1, 1).Select

M.

 

[Daintel]

Woah thanks it works perfectly.

Could you also help me solve this:


ActiveCell.FormulaR1C1 = "9" should bring the cursor to column "I" on the row in which my cursor is currently standing then it should enter "9" in the cell.

Thanks a lot.

 

[Marcelo Branco]

Woah thanks it works%

 

[Daintel]

Yes really great, we are nearly there

Then when the cursor is in column "I" , I would like that the macro enters the number "9" in the cell.

Thank you so much.

 

[Marcelo Branco]

Yes really great, we are nearly there

Then when the cursor is in column "I" , I would like that the macro enters the number "9" in the cell.

Thank you so much.

You are welcome
(i tried to edit my last post and lost it...)

try this

Rows(ActiveCell.Row).Cells(1,"I") = "9"

M.

 

[Daintel]

OK thanks a million. Right now on a phone meeting but will try very soon.

 

[Marcelo Branco]

Hey,

You dont need the quotes to enter a number, simply enter 9 without quotes.

M.