Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
posting data to the message boardPosted 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.
Re: posting data to the message boardPosted 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.
Thanks Juan PabloPosted by Eric B on January 15, 2002 7:23 AM
Works as advertised when I include the brackets in the copying procedure,
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.