[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?

Torstein

__._,_.___

---

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:
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

.

__,_._,___