How do I run a forumla in a macro?

[gshock]

I'm writing a macro to clean up some data that we read in from a text file. My macro cleans up and sorts into columns, and I want to re-order the data in two columns from top to bottom. I was trying to paste this formula "=INDEX($A$1:$A$100,ROWS($A$1:$A$100)-ROWS($A$1:$A1)+1)" into a group of cells. But I'm getting a compile error. I've tried with, and without, quotes.

Not sure what's wrong. Suggestions, or a simpler method?

Thanks,

-gshock

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[gshock]

Yes, that will do. That will do nicely. Thanks very much.

What is the reason for

Please Login or Register  to view this content.

I don't understand the meaning of the "space" after the = and the "underscore."

Thanks for the help.

-gshock

[VBA Noob]

Instead of a long string of code you can use the space and underscore as a sort of carriage return to keep the code easier to read.

Without the return the code would look like the below

Please Login or Register  to view this content.

VBA Noob

[gshock]

Instead of a long string of code you can use the space and underscore as a sort of carriage return to keep the code easier to read.

Without the return the code would look like the below

Please Login or Register  to view this content.

VBA Noob

Great. Thanks for the help. I'm building "Macro City."