Hi All,
I have a array i have dimensioned as BlkDataNew(1 to x, 1 to 7) with x being a variable.
After my calcs are processed i end up with some rows being blank i.e 1 to 7 is empty, how do i delete all the rows where 1 is empty (if the 1st is blank the rest are).
and once i just have records in the array that have data can i transfer to a worksheet in one swoop or do i have to loop through the array and put each value individually.
Any steer would be very welcome.
Regards
Taz
I have a array i have dimensioned as BlkDataNew(1 to x, 1 to 7) with x being a variable.
After my calcs are processed i end up with some rows being blank i.e 1 to 7 is empty, how do i delete all the rows where 1 is empty (if the 1st is blank the rest are).
and once i just have records in the array that have data can i transfer to a worksheet in one swoop or do i have to loop through the array and put each value individually.
Any steer would be very welcome.
Regards
Taz