Hi
I have a worksheet with a few hundred data columns (containing 500 rows) of historical stock prices each with a heading (in my case, the ticker of the asociated stock).
I wish to automatically name the columns as the respective tickers.
What I want is something like this
here c is the column number. and the data is from rows 3 to 503.![]()
Please Login or Register to view this content.
I cant get the syntax right, or I keep getting a global range error.
Please help.
Bookmarks