Cell refferences in a macro

Hi all,

I have been trying to use a date range as criteria for a macro to both delete some rows and add data to other rows.

I have attacked this from many different angles and stressed myself near to insanity, but I think I am very close now, to the solution that is.

I have a macro to add a sheet and it has two InputBoxes that ask for the start date and the end date, these are then changed to a number so it can be used in another macro.

Please Login or Register  to view this content.

Then I Try to refer to these cells, B1 and B2 in another macro.

Please Login or Register  to view this content.

This does everything I want except when it inputs the formula into the cell it comes out as

Please Login or Register  to view this content.

It would work perfectly if it came out

Please Login or Register  to view this content.

The ' either side of the B2 is stopping the macro from being successful, does anyone know how I can get them to stop appearing, or even if there is a better way to do this.

I am then going to do a simple macro to delete all rows where the word delete appears in row L.

Thanks
Brett