VBA to change font formatting

Hi All,

I have written a code that mainly copy's and paste's data between workbooks. This all works fine until I tried to format the font in a particular cell with code. I just cant seem to get my head around whats causing the problem as I use the same snippet of code twice in the same module. the first time it encounters the snippet of code to format the font it fails, but if i delete it and only leave in the second bit of format code it works fine. Hard to explain so I have posted my full code below and highlighted in red where the code runs into an error

Please Login or Register  to view this content.

The error i receive is "Run-time error '1004': Unable to set the Name property of the font class"

If I remove the name property it simply fails on the next line of code. If I remove the whole section the code runs including the identical code just below the offending bit of code.

I am new enough to VBA so maybe it is something simple i have overlooked. Or even any advice on how i could clean up this code would be appreciated.

Thanks in advance

Simon

I understand what you are saying, makes sense to me, but it still not working. As you can see below the highlighted RED code, the code just copies and pastes the same information to another sheet. If I delete the whole first bit (highlighted red) and run the code it works fine. formatting the text and all.

Please Login or Register  to view this content.

The more time i spend looking at it the more stumped I get, I have extracted the code and modified it to run just the formatting on a completely separate workbook and it works fine.

Also rows.count wont be necessary as it will always be "F5" that i want to format

Thanks for taking the time to reply, unfortunately when I insert your bit of code it still returns the same error as I mentioned in the first post :-S

I was preparing some workbooks to upload as they hold a lot of sensitive information. I had to delete some sheets and macros that wouldn't be necessary for an example. Then I had my example workbook ready to upload, so I said I will run the code again. And lone behold it ran perfect no issues. I didn't make this document and am only modifying it so had overlooked any clashes of code, which seems to be the case. But only thanks to you asking for an example workbook I came across the issue. That deserves some rep!

Thanks all for your replies

Simon