I find the table function via taskbar to be a pain.
How do some of you post such long tables in posts
like Tony here
http://www.excelforum.com/excel-form...ank-cells.html
or SHG here
http://www.excelforum.com/excel-gene...-of-times.html
Is there a tricck to it?
Thanks in advance
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It's done through VBA.
Take a look at this thread: http://www.excelforum.com/suggestion...-and-data.html
and the Excel add-in at the following link: https://www.dropbox.com/s/31r9s6t9j6...ools.xlam?dl=0
EDIT: the add-in was found at Rory's website (http://excelmatters.com/excel-forums/) and contains code from a number of EF contributors, incl mlcb and shg from the above thread.
Cheers,
berlan
Last edited by berlan; 08-13-2015 at 03:56 PM.
Follow the link at the bottom of Tony's post.
I use this for mine
I had to change teh extention from .xlam to xls so it would uploadHope you can just save it and rename
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ah Ah! I have some reading to do.Thanks berlan!
See Links in my signature
and here
http://www.excelforum.com/tips-and-t...um-thread.html
http://tinyurl.com/nl2ygjv
anh here
http://www.mrexcel.com/forum/about-b...rder-help.html
http://tinyurl.com/nlvzanj
Last edited by Doc.AElstein; 08-13-2015 at 04:24 PM.
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
I managed to zip the file that Ford uses (I use that too) by using Window's compressed folders feature. I think that the install involves unzipping then double clicking the decompressed file. Then in Excel options, Add-ins, Select Excel Addins at the bottom of the window, click GO and then select the Excel RangeToBBCode V0.2.xlam.
I hope this helps.
It is a rather useful tool. I think that the authors are listed in the code and thank you very much to all who developed this.
The ExcelForum should have an area with such utilities for use in EF ready for download so that one doesn't have to go searching.
Last edited by newdoverman; 08-13-2015 at 05:58 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks