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