unfortunately, that is how the web content was setup. not my choice, I just
have to work with it.

"Dave Peterson" wrote:

How do you know what cell to process? Is it the activecell?

Workbooks.Open Filename:= _
"http://total." & activecell.value & "." & activecell.value & ".htm"

(Did you really want that value duplicated?)

Btobin0 wrote:

Right now Ihae it wher in the code below, if information is added to A1 then
it will fil out the rest of this web link and then run a macro to copy and
paste. I want A1 to be any cell in the worksheet.

"Dave Peterson" wrote:

I don't understand how this fits into a Search. I guessed you were doing the
same thing as Edit|Find in code.

Maybe you could restate your question.

Btobin0 wrote:

ok here is my code snippet. I am trying to get the A1 turned to the
activesheet.used range. How do I set this up?

Workbooks.Open Filename:= _
"http://total." & Sheet1.Range("a1") & "." & Sheet1.Range("A1") & ".htm"

"Btobin0" wrote:

you have a period at the end of used range. is there more to it?

"Dave Peterson" wrote:

In the .find statement

..., After:=activecell, ...

or specify whatever cell you want to use.



Btobin0 wrote:

I have a macro where I can search from A1 but I would like to search from
anywhere in the sheet. Does anyone know how to do that?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson