Leave Entry Excel Sheet - Need help with VB Macro debugging

[yasararafat7107]

Dear all,

I have this Leave entry excel sheet done using VB Macro.

But when I try to save a record, I get the following error:

.Cells(ContRow, ContCol).Value = .Range(.Cells(11, ContCol).Value).Value


Does anyone know how to resolve this error?

The Excel document is saved with this post.

Thanks in anticipation for your help!

[Greg M]

Hi there,

The following version of your code seems to "work" (insofar as no error messages are generated) but, as I'm not sure of what your precise requirements are, it may require further modification by yourself:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M