Trouble Setting a cell to a value

So i have this code, that unmerges some merged cells and then applies border
then i'm trying to set the value of the empty cells and its not working

The setting of the values is closer to the bottom of the code
There are two checks, one msgbox that says "its here"

and another that says "its here2" after the setting of the values

the second msgbox never comes up and has me very confused

anyone got any ideas?

Please Login or Register  to view this content.

anyone atleast have any ideas why it might be skipping that code?
or appear to be skipping the code

Try running your code as a sub
Functions return values they don't perform actions with objects.
Mick G

yea i tried it outside the function and all is well
thats kinda annoying, but o well

thanks for the help!