Hi I'm having trouble setting a range that includes A1 down to last row and a static number of columns .
I am able to set MyRange dynamically
,but am unsure how to extend this to Column DN
the header row A1 to DN1 does not contain blanks
I'm sure the answer is an easy one but i am stumped!
any help would be gladly appreciated !
I am able to set MyRange dynamically
VBA Code:
Set MyRange = Range("A1",Range("A1").end(xldown))
the header row A1 to DN1 does not contain blanks
I'm sure the answer is an easy one but i am stumped!
any help would be gladly appreciated !