findNEXT should be faster. See my code.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: JLO
Sent: Saturday, June 16, 2012 8:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ change content of cell across multiple worksheets
David, you'
nt: 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
David, you're a Star! Thank you so much - didn't expect the counter
addition - very thoughtful of you. It works brilliantly!
Orange on its way...! :-)
On Saturday, June 16, 2012 12:05:30 PM UTC+1, David Grugeon wrote:
> Final version including force uppercase input and counter so you know what
Final version including force uppercase input and counter so you know what
it has done
Completed with Ucase and Counter.
Sub UpdateCode()
Dim mySearch As String
Dim myReplaceValue As String
Dim ws As Worksheet
Dim c As Range
Dim Counter As Long
mySearch = UCase(InputBox("Enter the Box Number re
Sorry - hit the send button too quickly
Option Explicit
Sub UpdateCode()
Dim mySearch As String
Dim myReplaceValue As String
Dim ws As Worksheet
Dim c As Range
mySearch = InputBox("Enter the Box Number requiring relocation: ")
myReplaceValue = InputBox("What is the new location? ")
For Each ws
Hi Jeanette
Try the following. It assumes that the sheet names of 1 character length
are the ones you want to work with. If this is not so you will need to
change the line
If Len(ws.Name) = 1 Then
to apply a more appropriate test.
On 16 June 2012 10:18, JLO wrote:
> Could really use some he
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
e
