Copied a number, but not right-aligned

[devGarfield]

Hi,

I'm copying a range of cells from one sheet to another. One of the cell columns has a number in it which is used in a formula, the formula shows #N/A as it doesn't thinks its a
number. However, if I re-type the number in the cell the
formula works.

Any ideas as to why this may be happening and how do I correct it.

Garfield

 

[xlbo]

BEFORE you paste the cells, check the cell formats - if they are text, change to general and then paste

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[SkipVought]

Please post your code

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[devGarfield]

Here's a snippet of the code where I copy. I'm copying column by column from one to the other.

Range(Cells(FacDep, 8), Cells(FacDepCC, 8)).Copy Sheets("Calculator").Range("E28")


example of the row created: the invalid number is 30 in this case

Basic Literacy Course, Level 1 AHH698EL3 CBS10001 LB 30 F 5 #N/A