Active sheet / cell programming question

[welchs101]

I have the following code

Please Login or Register  to view this content.

Which i thought would "select" cell G2 on the appropriate sheet and then paste the formula. However, what i get is the formula pasted into a totally different cell. To get the formula pasted into G2 i actually need to have the following code.

Please Login or Register  to view this content.

Does anyone know why? I think its a "selection" issue but i am not sure.

DAvid

[davesexcel]

Try this code, change the names of course...

Please Login or Register  to view this content.

[welchs101]

thanks.......i will check it out. thanks.

So basically, i need to do a "set" first..........

[shg]

Your first construct looks fine to me. If you're using Excel 2007, you can shorten it to

Please Login or Register  to view this content.

[welchs101]

Thanks. But for some reason i need the additional line of code with the "Application.goto" statement otherwise the formula is put into the wrong location. Cant figure out why.