unable to write data to sheet using currentRegion.Rows.Count

[sumit dey]

hi,

I am using the below code to write data to excel sheet using a userform but, it shows 'Run-time error '9': subscript out of range.

the code I am using is:

Please Login or Register  to view this content.

continued.......


please help on this

[JBeaucaire]

That error means VBA cannot find the object you supplied by name. The sheet "datasheet" perhaps can't be found.

[HaHoBe]

Hi,

try

Please Login or Register  to view this content.

IŽd go with using the end-command from the bottom to find the last used row and offset from there.

Ciao,
Holger

[sumit dey]

That error means VBA cannot find the object you supplied by name. The sheet "datasheet" perhaps can't be found.

Shall I rename the datasheet to default sheet1 and update code?

please advice if there are other alternatives.

Thanks

[sumit dey]

Hi,

try

Please Login or Register  to view this content.

IŽd go with using the end-command from the bottom to find the last used row and offset from there.

Ciao,
Holger

The code seems to be similar with the one I have worked on.

Please check and advice any othet alternatives.

thanks

[HaHoBe]

Hi, sumit dey,

Please check and advice any othet alternatives.

ShouldnŽt you at least try the code posted here and report back opposed to using wrong commands in your sample and asking me to update a code which at least is showing the proper commands?

Bye,
Holger