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

'name-A
'age-B
'department-C
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!

Regards

Torstein

__._,_.___

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:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar