(1) to test whether a cell has a formula use
eg.
If Range("A1").HasFormula Then
* * * * 'do something
End

um, maybe I didn't explain it correctly. I know how to check if a cell
has value, as it was allready doing that, and copying the formulas,
but not the values which is what i would really need copied.


(2) can you record a macro and look at the VBA code written?

allready tried that, but that copies true values/formulas/etc and
really dumbs it down, so that if i add more subjects down the left
side, it makes it very hard to copy/paste back into the live document
and causes problems.

(3) yes.

Would it be possible to simplify the process? It sounds like a lot of
moving parts. Think of avoiding copying across to several other
workbooks, copying from/into different ranges.

yea, i could do copies to different ranges, but when I give an updated
document to friends with the added subjects/etc, I want to have one
macro they can run to backup there custom values, then they update the
document and run another macro to move in all there backed up data
into the correct fields, based on the first Column and fills in values
into other cells to the right.

I have been playing with it today, and got most all of it working,
it's not a pretty code, but it semi-works. Main thing right now is how
to use the follow line, and ONLY copy over the values, and not the
full formula.

btw, thanks for the reply!

I'm assuming something in the following line has to be changed, or
added to only copy the values, and not the formulas but I could be
wrong.. and ideas??

.Range("A" & RowCount & ":C" & RowCount).Copy _
Destination:=bk.Worksheets("Test").Range("A" & lRow)