Jumat, 15 April 2016

[ExcelVBA] Re: select range


Well, you need to check out the vba help on offset and resize; offset is a bit like the worksheet function OFFSET. Both offset and resize have 2 arguments, row and column in that order, and by leaving any one argument out altogether, the function doesn't try to alter that dimension. So .Offset(,3) offsets the range by 3 columns and no change in row offset. Similarly, .Resize(,3) would only resize the range to 3 columns wide without altering the number of rows. Vba Help is your friend here.

---In ExcelVBA@yahoogroups.com, <sejohnse@yahoo.no> wrote :

Pascal and Derek

Thank you for still more elegant solutions.

But these are way beyond my VBA-knowledge.

I see that they are working, but how?



Posted by: pascaldaulton@lineone.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)
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