Formula Range

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

How can I make the below formula range consist of columns B and D, still
using the bottow row finder of .End(xlup) ? Thanks!

Set frng = Range("B5:B" & Range("D65536").End(xlUp).Row)
 
Set frng = Union(Range("B5:B" & Range("B65536").End(xlUp).Row), _
Range("D5:D" & Range("D65536").End(xlUp).Row))
 
Thanks Bob!

Bob Phillips said:
Set frng = Union(Range("B5:B" & Range("B65536").End(xlUp).Row), _
Range("D5:D" & Range("D65536").End(xlUp).Row))


--

HTH

RP
Click to expand...
 
You must log in or register to reply here.

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

Array with many cells from a row but not in order or together 11
Paste in column B using Last row of either column B, C or D. 10
VBA set thick borders around non empty cells in range 0
Copy columns and paste with blank column between 5
End process at last row of data 3
Post my named ranges in column A 10
Copy a range instead of just one row but with condition 8
Copy and Paste Macro 5

Back
Top