hi all !!
i need a sub for filling each cell from row 2 to row 300... and from column
A to column W....

i need in each of those cells a link to cell K22 of a lot of the
correspective pages that i created yet with this syntax.....
C:\WOW\FEEDERPAGE.B.3.xlsm
ty for all

Hi,

We need more info, show us one of the completed formulas and tell us how it
change in the range A2:W300.
I don't follow the part that reads:

"i need in each of those cells a link to cell K22 of a lot of the
correspective pages that i created yet with this syntax.....
C:\WOW\FEEDERPAGE.B.3.xlsm

What do you mean by link all cells to K22 on correspective pages?

When it comes to writing code we need to know detail, not generalizations.
--
Thanks,
Shane Devenshire


"pls123" wrote:

hi all !!
i need a sub for filling each cell from row 2 to row 300... and from column
A to column W....

i need in each of those cells a link to cell K22 of a lot of the
correspective pages that i created yet with this syntax.....
C:\WOW\FEEDERPAGE.B.3.xlsm
ty for all

Sub RoundToZero2()
For Each c In Worksheets("Sheet1").Range("A2:W200").Cells
c.Value = "What you want it to be"
Next
End Sub

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"pls123" wrote:

hi all !!
i need a sub for filling each cell from row 2 to row 300... and from column
A to column W....

i need in each of those cells a link to cell K22 of a lot of the
correspective pages that i created yet with this syntax.....
C:\WOW\FEEDERPAGE.B.3.xlsm
ty for all

hi sheeloo ty ..
to build the link to the external page i need to use & c.Row ....
and a if then inside a for next..
do you think it is possible ..???..because it doesn't work....

i could build all this with text editor and paste links to all the
pages..but it returns error in case of absence of the linked page...and it
prompts to a link edit menu..
instead of indicating void or zero...

ty for help evrybody !!




"Sheeloo" wrote:

Sub RoundToZero2()
For Each c In Worksheets("Sheet1").Range("A2:W200").Cells
c.Value = "What you want it to be"
Next
End Sub

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"pls123" wrote:

hi all !!
i need a sub for filling each cell from row 2 to row 300... and from column
A to column W....

i need in each of those cells a link to cell K22 of a lot of the
correspective pages that i created yet with this syntax.....
C:\WOW\FEEDERPAGE.B.3.xlsm
ty for all