Formula written as Macro

[ALEZI]

Hello Guys,

I have one question for you,

I want to exucute formula in cell A1 (and A2 also) in whole column A,off course formula should be change as row number changes,

can you do this thru the Macro somehow?


Thank you in advance.

[martindwilson]

why not just fill the formula down?

[ALEZI]

Actually i tried to rewrite my formulas in workbooks as Macro and execute them,can i do this somehow

[martindwilson]

you really want the formulas to go down to row 1048576

[ALEZI]

No,enough is 10 000 rows

[martindwilson]

so is the formula already there or does it have to be included in the macro
maybe something like this

Please Login or Register  to view this content.

[ALEZI]

Thank you it works..

[TMS]

If you're going to use a macro to drop formulae into a column, you don't really need to use FillDown

This will do the same thing:

Please Login or Register  to view this content.

Regards, TMS

[martindwilson]

saves typing!

[TMS]

@Martin: maybe


@ALEZI

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.