Compile Error: Expected End With

**Robert110** · 02-13-2013, 02:16 PM

Hi,

I have been recording 3 separate Marco’s in excel and now would like them to become one.

The separate Marco’s are:-
1) To format a header, and copy an “If” statement in to cell K4
2) To fill the copied information in K4 down to a dynamic range
3) To conditional format the rows that have "Yes" in the column K.

The script is below, but I get the error "Compile Error: Expected End With"
I have tried many things but I can't seem to join these Marcos together.

I hope someone can help me with this, as this s is driving me crazy

Thanks in advance
Rob

Please Login or Register  to view this content.

**Norie** · 02-13-2013, 02:20 PM

Rob

It's hard to tell where the problem is without seeing the code in tags.

Could you edit and add them?

**Robert110** · 02-13-2013, 02:23 PM

Hi Norie

Ok I will.

Rob

**Norie** · 02-13-2013, 02:25 PM

Rob

You can (should?) add code tags so that it makes the code easier to read/copy.

The tags will preserve any indentation and will make the code stand out from the rest of the post.

To add tags, select the code and press the # button in the toolbar above the reply box.

PS Try sticking End With just before End Sub.

**Robert110** · 02-13-2013, 02:38 PM

Ok Norie, Thanks for telling me about the coda posting ,

Sorry I didn't know about the cods tag's I will do that in future.

I did try "End With" but it still errored.

I am working on a different computer at the min and don't have the code here with me. so I had to copy and paste the code from Excel to and e-mail and then post it on this thread
But if it helps I can get the code from excel tomorrow and post it in a code format.

Rob

**Norie** · 02-13-2013, 02:42 PM

Rob

I might have missed something - it is hard to read the code without the tags.

PS You can edit your original post to add the code tags.

**Robert110** · 02-13-2013, 02:50 PM

Norie,

Thanks for the tip, I will edit my first post. Once I get on the other computer.
Thanks very much for helping me

Rob

**Robert110** · 02-14-2013, 06:39 AM

Hi Norie,

I have added the code in the correct format to my first message. I hope this makes it a bit clearer now.

Thanks again for your help

Rob

**Norie** · 02-14-2013, 06:48 AM

Rob

That does help, the answer is still the same though - all you need to do is add End With just before End Sub.

Please Login or Register  to view this content.

**Robert110** · 02-14-2013, 07:14 AM

Thank you so much Norie, that worked perfectly.

To help me understand, why did I need an "End With" there, why wouldn't an End Sub just do?

Thanks again, this was driving me crazy:-)