Hi Lisa. Paul and Ashok!
First of all, my native language is not english and because of that my questions may be hard for you to understand, and your answers may be difficult for me to understand.
In spite of this I have got a lot of help, specially with VBA-topics!
So, please, let me ask silly questions when I don't understand you!
And now I understood your solutions!
Experimenting with your solution I suddenly came over another one, hope you understand it :)
A1
shift-end-down (select all cells in column A)
shift-right (extends the range to column A and B)
shift-tab
right
And your question Paul - why?
Selecting all the cells in column B (down to the last used row) with shift-pgdn is quite cumbersome. With this few keystrokes all cells in column B are selected.
Thanks again
Torstein
[Non-text portions of this message have been removed]
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:
Posting Komentar