tag:blogger.com,1999:blog-28492262.post5229686212492104163..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: How to use non-contiguous range of cells in Excel VBAUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-28492262.post-69468767818007416732012-03-01T04:12:12.819-08:002012-03-01T04:12:12.819-08:00Excel add-in user
In both your examples shown &qu...Excel add-in user<br /><br />In both your examples shown "cell" does not represent a range in fact it does not represent anything.<br /><br />If you wanted a union on say cells(5,10) you could use:<br /><br />Set range_to_select = Union(cells(5,10), Range("a1"))<br />range_to_select.Font.Bold = True<br /><br />and<br /><br />Set range_to_select = Union(cells(5,10), Range("a1"))<br />range_to_select.selectAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-19255523556937884292011-11-03T04:15:11.300-07:002011-11-03T04:15:11.300-07:00How do i select a range non-contiguous range?
I h...How do i select a range non-contiguous range?<br /><br />I have built a range using a union:<br /><br />this works ok:<br /><br />Set range_to_select = Union(cell, Range("a1"))<br />range_to_select.Font.Bold = True<br /><br />but when I try to select the range, it goes crazy:<br /><br /><br />Set range_to_select = Union(cell, Range("a1"))<br />range_to_select.select<br /><br />am i missing a "cells" somewhere?Excel add-in userhttps://sites.google.com/site/xltoptools/noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-78543063505190666132011-06-13T10:25:58.425-07:002011-06-13T10:25:58.425-07:00what is noncontiuos range of cellswhat is noncontiuos range of cellsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-71459666968188407092011-04-22T14:02:26.396-07:002011-04-22T14:02:26.396-07:00What if you want to build a non-contiguous range w...What if you want to build a non-contiguous range without hard-coding the addresses?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-77123236678353259032009-02-23T07:42:00.000-08:002009-02-23T07:42:00.000-08:00Many Thanks John. I have corrected itMany Thanks John. I have corrected itM Shasurhttps://www.blogger.com/profile/17390752937266096344noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-526913057443890862009-02-22T06:17:00.000-08:002009-02-22T06:17:00.000-08:00Your picture is the result of Range("A1, B5, C9")n...Your picture is the result of <BR/><BR/>Range("A1, B5, C9")<BR/><BR/>not<BR/><BR/>Range("A:A, B5, C9")Anonymousnoreply@blogger.com