RDBMerge

[louisjeorge75]

hi i am using the RDB merge but the data which is merged is getting pasted in column A:B if i select the fixed range as A:b in RDB merge but i require the data from each sheet to get pasted in next column like A:b c:d etc how can i acheive this

 

[matthew230]

I'm not sure I understand this, but if you want to select empty columns, you could use the .end function

Range("iv1").End(xlToLeft).Offset(0, 1).Select

This will select the first cell in the first empty column