Formula not being row specific

[KevinThomas]

Hi, If I want to paste a formula into a sheet using a macro, how can I go about this if the row number is not specific.

For instance, If I was selecting cell A5 I want the formula to be =if(d"the row number here">10,”yes”,”no”).

But how do I do this to cover a range of rows? I would firstly select the row, so for instance row 5 column A – and then run this macro to apply to the values in D5.

Thanks

[NBVC]

Not sure about your macro but the formula would be something like:

=if(INDIRECT("d"&ROW())>10,”yes”,”no”)

[KevinThomas]

The sheet is very changable, hence why I need it to allow the user to enter the formula on certain rows by clickig a button (using a macro).

I just need the formula to paste into A1, 2, 3, 4 etc on users choice - but the formula needs to be specific to that row.

[shg]

Please Login or Register  to view this content.