asked on

How to direct an output of a VBA excel script to the same worksheet is being run from

An Expert here (Daniel ) excellently helped me in a script that made my task super easy (it's located here). The VBA extracts all the comments from a specific worksheet and lists them with links.

I am trying to modify the script so instead of placing the list in a separate worksheet, save the list in the same worksheet I am calling from to column U.

Help please!

Daniel Pineault

Jana,

Just want to understand the request properly. You would like to generate the summary result table starting on column U1?

U1 -> No
V1 -> Source
W1 -> Author
X1 -> Comment

and used row 2 and on to list the comments. Is that right?

ASKER CERTIFIED SOLUTION

Daniel Pineault

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jana

ASKER

Thank u, Yes!

But the links are not pointing to the cell where it was pointing to in your previous script (gives an error hen clicking the link)

Daniel Pineault

I'm sorry but I can't replicate the issue. Any chance you could post a sample for me to look over?

jana

ASKER

Hmmm... if u can't replicate it, let downloaded and run it as is...

jana

ASKER

Worked! Sorry... it was at my end!

Again, Thanx!

jana

ASKER

Hi same problem but I can re-created (open the attachment).

If you run as is, it it will give you the "Reference not valid" error message.

But if u change the worksheet name to NOT have spaces or "-", for example "VBA" works.

Up to now I see that space and "-" causing the error.

What do u think?
VBA.ExtractCommentsError.xlsm