Strange Formatting Issue VBA data import

[ChrisBrown]

Hi, Please be gentle this is my first post on here.
I have an Excel Spreadsheet (XLSM) which imports data from a database using named ranges. All but one work perfectly well.

The problem lies in one which is importing a table of data, starting from a particular cell. When the import is run the formats is applied correctly to the imported data. However the format is also applied to another sheet in the workbook and this is causing a problem for the remainder of the calculations. Even more strangely on the format for the first column is copied.

I have checked all named ranges and all data validations to ensure there is no cross over and also deleted the offending sheet, named range and recreated (with different names) - nothing seems to work

Any thoughts on what may be causing this? Is more info needed?

The offending code is
Range(nm.Name).CopyFromRecordset adoRs

adoRs contains the data.
nm is the name of the range which in this case is "Prices!$B$4"

The sheet where the format is changing is called "Inputs"

 

[RoryA]

Do you have more than one sheet selected at the time?

 

[ChrisBrown]

When the VBA runs the "Inputs" sheet is the selected one. The full process imports 10 tables to different sheets and about 80 other individual values.
All the other tables import without a problem, its just this one - of the 10 its the second one that is run.

 

[ChrisBrown]

Thanks for a pointer, I have solved it using:-
Sheets(nm.RefersToRange.Parent.Name).Activate
before I populate the range.

No idea why the others work and this one doesn't, a bit odd. But using this code has solved the problem.