Excel - copy a formula to a variable destination

[Rybrookar]

I have a spreadsheet that uses imported data of variable length (always the same width though). The data normally goes from cell A2 to R3000 (somethimes greater than 3000, somethimes less.

In cell s2 I have a formula. I want to copy this formula to s3,s4 etc all the way down to s3000 (or whatever the length of the data is). After this I want to convert the result back to values to save space and make the spreadsheet smaller (in mb size).

I can convert to values I think but I'm having difficulty in getting the VB code to copy to a variable destination.

Any help would be gratefully appreciated.

 

[AnotherHiggins]

Please create a new thread for this VBA/Macro-specific question in forum707

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[xlbo]

Please post in the VBA forum: Forum707

Also have a look in the FAQs there for methods to determine the last row of data

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Rybrookar]

moved over to the forum suggested - sorry for any inconvenience. Thanks