Code too long? Error 1004

I have created a module and it works for the task i require, so far. The thing is that when i change the formula that is to be inserted to a cell, the error 1004 appears, and claims application/object defined error.

here is the line that i change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

The only differnce is that i ask it to check for a blank cell, and use the correct formula. I would use VB to do this, but it needs to be able to use the code for several iterates of "fgh" which then changes the values of "d2" and "c2" to =fgh. The way i was to do this was autofill the cells from the above formula.

Any ideas appreciated.

Hi,
when you want to put a " in a string you must write "" instead. The condition should be:

Please Login or Register  to view this content.

Hope it helps.
w.

I managed to figure it out, but not quite sure on your wording. I figures that VB looks at every " as the start of a string, so whne i did "", it inserted nothing. I happend to hit the key three times and ened up with " so firgured you have to use four to get "" in the equation.

Thanks anyway