[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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___