Union Statement Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I write the Union statement for the union of range "r" and the
cell(r.row,r.column+1)

Thanks
 
Try this; it should work assuming that "r" is a range variable that has
already been set.

Set u_r = Application.Union(r, Cells(r.Row, r.Column + 1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Color Index + conditional Formats + validation 3
Value of True etc 5
Operations on union of ranges 2
Remove cell from range 2
Range created using Union...accessing cells 2
Union 1
Problem with Union 1
Variable range union 1

Back
Top