MrExcel Publishing
Your One Stop for Excel Tips & Solutions

posting data to the message board


Posted by Eric B on January 15, 2002 6:50 AM

A few months ago Juan Pablo and Aladin Akyurek walked me through a method for posting data to the message board using an array function. I can't find the original post and need a refresher course. Any help would be much appreciated.


Posted by Juan Pablo G. on January 15, 2002 7:05 AM

When posting TO do this. Select an empty cell, type = and select the area of interest. Then, in the formula bar, select the range (A1:B8 for example) and press F9. Copy what's in the brackets.

When copying FROM do this. Select an empty cell, type = and paste what you copied from the board. You can then count the number of ';' and ',' to find out how many columns and rows does the data have, or you can select a large area, starting from the empty cell selected above, press F2, and hit Control Shift Enter. Then, you can just copy as values to work with the data.

Juan Pablo G.

Posted by Eric B on January 15, 2002 7:23 AM

Thanks Juan Pablo

Works as advertised when I include the brackets in the copying procedure,
thanks again.