Columns Shifting on Import of Data

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
 
C

Carroll

Now all of a sudden, this sheet is now behaving itself. I can't think
of anything that I did that would have changed this behavior. Unless
someone has experienced this and knows the cause, I'm closing this
topic. Thanks anyway--Carroll
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top