C
Carroll
Hello,
I have an Excel Spreadsheet that contains multiple sheets. 5 of the
sheets are for importing text files, then other sheets used as reports,
have functions that refer to these sheets that are strictly for the
raw, imported data. I import the data using VBA. I have a range name
for each of the first 5 or 6 columns on each of these sheets, and the
data is supposed to fall within these ranges on import. I import the
data beginning on row 2 of each sheet, as I have column headers on row
1, which I use to identify the data. What I am finding is that for 4
out of the 5 sheets, the data comes in exactly as it is supposed to.
For the 1 sheet however, the named ranges get shifted over to the
right, as well as the column headers, and the data falls to the left of
them. I have looked at the VBA for each of these text imports, and for
the life of me I see no difference in them, other than the name of the
sheets. Does anyone have any idea why this might happen? I'm using
Excel 2002. If no one has any ideas, I may have to incorporate the
deletion, then renaming of the named ranges, as part of the VBA.
It just doesn't make sense to me that 4 out of 5 of the sheets are
unaffected by this behavior.
Thanks,
Carroll Rinehart
I have an Excel Spreadsheet that contains multiple sheets. 5 of the
sheets are for importing text files, then other sheets used as reports,
have functions that refer to these sheets that are strictly for the
raw, imported data. I import the data using VBA. I have a range name
for each of the first 5 or 6 columns on each of these sheets, and the
data is supposed to fall within these ranges on import. I import the
data beginning on row 2 of each sheet, as I have column headers on row
1, which I use to identify the data. What I am finding is that for 4
out of the 5 sheets, the data comes in exactly as it is supposed to.
For the 1 sheet however, the named ranges get shifted over to the
right, as well as the column headers, and the data falls to the left of
them. I have looked at the VBA for each of these text imports, and for
the life of me I see no difference in them, other than the name of the
sheets. Does anyone have any idea why this might happen? I'm using
Excel 2002. If no one has any ideas, I may have to incorporate the
deletion, then renaming of the named ranges, as part of the VBA.
It just doesn't make sense to me that 4 out of 5 of the sheets are
unaffected by this behavior.
Thanks,
Carroll Rinehart