Hi,

I was using the code

a = Cells(73,3).address

so this set
a = "C73"

How would I use something similiar to set a equal to an array

a = "C73:AA73"

Thanks for your help