Continuous Macro

[hstsunflower]

Hi There,

Is it possible to create a Macro that will continue through the end of my worksheet and be useable on other worksheets even if the number of rows with data changes?

ie; my worksheet contains 13526 rows. I would like to create a macro that will do the following in the same column down thru row 13526:
Selection.End(xlDown).Select
Range("A122").Select
ActiveCell.FormulaR1C1 = "x"
Selection.End(xlDown).Select
Range("A124").Select
ActiveCell.FormulaR1C1 = "x"
Range("A125").Select

and continue down through all rows to the end of row 13526.

I would also like to use this macro in other worksheets however the number of rows will definitely vary.

Thanks in advance for your help.

 

[hstsunflower]

Yes. Except for the bold subtotal row. (see above snip; "Keep", "A"Frame", etc)

 

[Fluff]

In that case you should get what you showed in post#9

 

[hstsunflower]

Yes. They are empty except for the bold titles shown in snip above. (ie; "Keep", ""A" FRAME", etc).

I just need a code that enters an ex in every immediate row below the title. All other rows will remain blank.

ie:
end
down arrow
down arrow
x

I need that repeated through the entire worksheet for column A.

 

[Fluff]

That is what the code will do, if the cells are truly empty.

 

[hstsunflower]

Question: Where can I get decent Macro, Pivot Table and VB code online lessons without paying an arm and a leg for. I have beginner experience but looking to build on that.

Thank you.

 

[Fluff]

I have no idea I'm afraid.