paul_0722
05-14-2008, 11:00 PM
A VBA newbie qeustion...
I want to copy rows of data using something like Rows("A3:B5").Select but the values of the range to be used are stored in an array called data() so I want to say something like Rows(data(1):data(2)).Select - but the VBA complier is saying that isn't allowed!
Can someone point me in the right direction? ...many thanks
I want to copy rows of data using something like Rows("A3:B5").Select but the values of the range to be used are stored in an array called data() so I want to say something like Rows(data(1):data(2)).Select - but the VBA complier is saying that isn't allowed!
Can someone point me in the right direction? ...many thanks