sub for filling each cell of the grid
 

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 for filling each cell of the grid
 

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

sub for filling each cell of the grid
 

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 for filling each cell of the grid
 

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