show last cell value in message box

[mubashar]

whats wrong with this code at msgbox line, it show error .The code is placed in command_click button

Please Login or Register  to view this content.

[HaHoBe]

Hi, mubashar,

maybe just use

Please Login or Register  to view this content.

You canīt assign the values of a range to a string like you tried to do, you would need a loop for that.

Ciao,
Holger

[gsnidow]

mubashar, you are trying to set a variable, 'maritvalue', equal to the value of a range. This would essentially make its existence redundant, even if you could do it. Secondly, MsgBox displays string variables, not objects. If you only want to see the value of the last cell in the range, you could incorporate something like this in your code.

Please Login or Register  to view this content.

Greg

[mubashar]

thanks to both of you, with your help it has been solved

[stnkynts]

To add onto what Hahobe said the loop would be something like this:

Please Login or Register  to view this content.

[HaHoBe]

Hi, mubashar,

do you mind to mark this thread as Solved via Thread Tools?

Ciao,
Holger