Extract Line From Comment

**Vic Schoeman** · 03-10-2011, 05:21 AM

I have placed 5 lines of info in a comment and need to extract only line three.

Can anybody help me please, I'm a new user and will appreciate help as a dummy

Thank you

Vic

**Steffen Thomsen** · 03-10-2011, 05:33 AM

Hi,

Where have you placed the comment?

If it's in a macro just remove the ' sign before the commented line.

Steffen Thomsen

**DonkeyOte** · 03-10-2011, 05:38 AM

Assuming the comment (A1 in ex.) has line breaks you can Split the comment accordingly and use the (2) item [0 based Array], eg:

Please Login or Register  to view this content.

you may want to add Error handler accordingly

**Vic Schoeman** · 03-10-2011, 06:56 AM

Thank you DonkeyOte, I know that is what I wanted.
I have written as follows:

Please Login or Register  to view this content.

Then I get the message:

"Object variable or with block not set"

Can you help me with that please and thank you

Vic

**DonkeyOte** · 03-10-2011, 07:04 AM

Vic, please always encase VBA code with CODE tags (per Forum Rules)

You would get the error you describe if the ActiveCell does not contain a Comment - this was the point I was making re: adding an appropriate handler.

Please Login or Register  to view this content.

with the above - if the cell is comment-less or contains fewer than three distinct lines then RmNo variable will be a Null string

Obviously when you refer to "comment" I have assumed you're referring to cell comments and not just a text string within the cell itself.