I have a relatively simple Excel sheet where a user will paste in 20 fields
of information from another application. Then to the right are 10 formula
fields that need to be copied down. Record count will change each time the
template is used. Is there a way to have a macro determine how far to copy
down and then do the copy down?

I wanted to do an xlDown to bottom of pasted area, then tell it to go over
one field, mark with an "x" to spot the bottom, then do a copydown to the
"x". Problem I am having is telling Excel to go over absolute 1 field
regardless of row location. Macro keeps recording actual cell address not
relative movement.

Can anyone help?

c-