Issue with populating a cell with a VBA

Hello there,

Help please. I'm really stuck in here and I don't seem to manage to resolve the issue. Your help is much appreciated.

I've got the following code, which mainly consist of populating a form-like worksheet (PDF Form (pf)) with certain values from the main data called Energy Data (ed).
The issue I have is that everything appears to be working up till the one highlighted in red. That number 100 is not showing in the range frm_scht which is a merger of cells P2:V2.
Is there any reason why it doesn't execute properly?
Thank you.

Please Login or Register  to view this content.

Hi Sintek,

Thanks for reminding me Not always easy to provide the workbook by masking all the data. Here it is...

the 2 ActiveX controls on the PDF Form (pf) are sitting above 2 merged cells ranges which corresponds to frm_scht and pf_scht

I've managed to make it work but still confused why I didn't not manage with my initial formula as per my initial post.

Thank you.