Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns Shifting on Import of Data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns Shifting on Import of Data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shifting rows into columns | Excel Discussion (Misc queries) | |||
Deleting and shifting cells and columns | Excel Worksheet Functions | |||
Import data into seperate columns | Excel Discussion (Misc queries) | |||
import data to specific columns | Excel Discussion (Misc queries) | |||
how to delete cells without shifting and rows/columns | Excel Programming |