Rabu, 21 Januari 2015

[ExcelVBA] VBA tips


I use to manipulate excel lists by making macros in VBA.
Then I often have to go back and forth between sheet and VBA editor to check which information in which column
Until I found this solution which has helped me, and maybe will help some of you:
I copy the titles and paste them into a column, switching rows and columns
In next column I enter a formula '="'" &A23&"-"&CHAR(64+ROWS($B$23:B23)), and copies it down
 It gives me a list like this

and so on

This list is easy copied into the sub as comments and gives me a brief column overview, without having to switch
Hope this is helpful for some of you!




Posted by: Torstein Johnsen <sejohnse@yahoo.no>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar