Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Data into an Array
I have 100 rows of information in an excel file bu there are about 200 or so
blank lines. does any one know the code that I can use to load the information into an array less the blank lines the place them into a different area of the worksheet Thanks -- Helping Is always a good thing |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Data into an Array
suggestion 1
you could just delete the rows for rn = 500 to 1 step -1 if cells(rn,1)="" then rows(rn).Delete end if next suggestion 2 copy data to a new sheet then delete the blank rows "QuietMan" wrote in message ... I have 100 rows of information in an excel file bu there are about 200 or so blank lines. does any one know the code that I can use to load the information into an array less the blank lines the place them into a different area of the worksheet Thanks -- Helping Is always a good thing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems Loading Large String Array into Array variable | Excel Programming | |||
Loading an Array | Excel Programming | |||
Loading data into an array | Excel Programming | |||
Loading array into list box | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming |