extending the number refernce cells passed to .range function in VBA
I am using worsheet.range("Relevantcells") to copy cells in a sheet. I have non contigous cells and hence it only let's me put in 60 specific cells. How can I extend this to many more cells that I want to read from?.


extending the number refernce cells passed to .range function in VBA
===

I am using worsheet.range("Relevantcells") to copy cells in a sheet. I have non contigous cells and hence it only let's me put in 60 specific cells. How can I extend this to many more cells that I want to read from?.

