Sleeper: Loop through range to copy/paste hyperlink

Quote:

---

Originally Posted by pdeshazier

It's not executing on every sheet. Only the sheet the cursor happens to be on. Any way I can attach my file? I uploaded it, but don't see that it's attached so you can see it..:bug:

---

Pam,

Use this site and load it there, and let me know the URL it gives you http://cjoint.com/index.php

it's running multiple times on the active sheet's column rather than running once then going to next sheet and running , etc.

just now saw that you sent this. trying to load it there, but got this:
Warning: unlink(): No such file or directory in /home/cjoint/www/index.php on line 180

Warning: Cannot modify header information - headers already sent by (output started at /home/cjoint/www/index.php:180) in /home/cjoint/www/index.php on line 454

Pam,

If you put it in a zip file, you should be able to add it to your post here. There is an Additional Options part below the message box that has an Attachments section.

I have just posted a working example at that site at http://cjoint.com/?fEw438qiRC

Quote:

---

Originally Posted by pdeshazier

... Can you suggest how I should get started learning it? ...

---

Hi Pam,

Welcome to VBAX, aside from our help forums, VBAX also offers training and certification in VBA, have a look here http://www.vbaexpress.com/training.htm or have a read through the first lesson for free here http://www.vbaexpress.com/training/lesson01.htm

Regards,
John :hi: