Posted to microsoft.public.excel.programming
|
|
find sheet
Stan,
Have a look he
http://www.cpearson.com/excel/ImportBigFiles.aspx
DB
"stan" wrote in message
...
I have a small marco that loads data from a file from another application
into a workbook in Excel 2003. Sometimes the number of rows exceeds the
65,000+ cap so the remaining data spills over to a second sheet, sometimes
not.
I need a line or two that looks for sheet2: if it finds id it copies all
the
data from sheets 1 & 2. If there is no sheet 2, the procedure continues
and
it loads sheet 1.
Nothing I try seems to work. I am a beginner with VBA.
--
stan
|