Global Fail

[k2hunter]

Hi I've been working on this code and now I'm stuck. Hoping anyone can help me out cleaning up and or fixing errors.
This line

Please Login or Register  to view this content.

I receive runtime 1004 method range of object worksheet fail

Thanks in advance!

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[Fluff13]

Alternately

Please Login or Register  to view this content.

[k2hunter]

Alternately

Please Login or Register  to view this content.

this would in a sense just populate all the cell with the function?
the populated cells would still check the value in column A* correct?

[Fluff13]

Yes that's right, it's doing exactly what your code is trying to do.

[k2hunter]

Thank you I actually will use this since it reduces code

however I'm still getting the global fail error

Please Login or Register  to view this content.

[Fluff13]

Have a look at that line & compare it to the line above where it inserts the formula.
See the difference between how the ranges are laid out?

[TMS]

Look at the line of code above it and make similar changes.

[k2hunter]

Thank you I actually will use this since it reduces code

however I'm still getting the global fail error

Please Login or Register  to view this content.

OK yes I changed the formatte of how it was coded and it runs with out error on the lines I've changed.
I hate to keep posting for each error however is it only syntax or did I declare incorrectly? since now the error is on

Please Login or Register  to view this content.

[Fluff13]

You cannot select a cell on a non-active sheet.
What are you trying to copy & where do you want to paste it?

[k2hunter]

the functions will run on WS2
then be copied and pasted to WS1 as text this might be excessive but I'm trying to avoid running the macro after each execution.

[Fluff13]

How about

Please Login or Register  to view this content.

[k2hunter]

ok thanks yes that seems to be working. I appreciate the time

just out of curiosity is there a way to have the macro run only when the "button" is clicked and not every time an entry is executed on the workbook? I tried to change the options for automatic to manual but then the macro wont even run.

[Fluff13]

How are you trying to run the macro?
That is not an Event code, so it should not be running automatically, unless you are calling it from another code.

[k2hunter]

on WS1 I have a button to run the script on WS2. however if I enter a new value such as adding a new link to check it runs the whole macro again. once I push enter

[Fluff13]

If the code is assigned to a button, it should only run when you click the button.