Copy one cell and paste into a range of cells in same row

Hi,

I've been working on a spreadsheet where I'm changing formulas and wanting to copy and paste those formulas to the rest of the row. For example, i'm using a macros to look up the last row and replace with a new formula. Then copying that formula and pasting it down the row. My VBA is:

Please Login or Register  to view this content.

Sometimes it works and sometime it doesn't.. i can't figure out why the formula doesn't paste across the selection. Any ideas and help would be greatly appreciated!

Thanks,
CMc

Moderator Note:

Pls use code tags around your code next time as per forum rules.