I’m not sure what you are trying to do but tested finding 1000 in column O and
putting 1200 in the cell 4 columns to the right
Assuming the code provided does work as desired, try this to use findnext in
each sheet/
Sub tryit()
Dim ws As Worksheet
Dim mySearch As String
Dim myReplaceValue
Dim c As Range
Dim firstaddress As String
mySearch = InputBox("Enter the Box Number requiring relocation: ")
myReplaceValue = InputBox("What is the new location? ")
For Each ws In Worksheets
With ws.Columns("o")
Set c = .Find(mySearch, LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
c.Offset(, 3) = myReplaceValue
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstaddress
End If
End With
Next ws
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: JLO
Sent: Friday, June 15, 2012 7:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ change content of cell across multiple worksheets
Could really use some help with this. I have worksheets A to Z. I'm searching
for data the user has entered via an input box, then changing the data in cells
over to the right with the data the user enters via another input box. This
works perfectly on active sheet. What I need is for the exact same thing to
happen across worksheets A to Z (there being further worksheets that don't get
changed), so some sort of loop is needed. I've tried looping, but with
disastrous results!! I'd really appreciate a solution - I cribbed the example
from elsewhere and tailored it, but I'm stumped to get it to work across the
other sheets. Thanks in advance for all your help! Here's my code:
With ActiveSheet.Range("O:O")
Dim mySearch As String
Dim myReplaceValue
mySearch = InputBox("Enter the Box Number requiring relocation: ")
myReplaceValue = InputBox("What is the new location? ")
Set c = .Find(mySearch, LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
c.Offset(, 4) = myReplaceValue
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstaddress
End If
End With
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
