B
Btobin0
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?
anywhere in the sheet. Does anyone know how to do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
C01d
Instead of using Range("A1") in your code, use ActiveSheet.UsedRange.
This property represents the currently selected range in your
worksheet.
This property represents the currently selected range in your
worksheet.
D
Dave Peterson
Actually, Selection would refer to the current selected range.
Activesheet.usedrange refers to what the range that excel thinks has been used.
Activesheet.usedrange refers to what the range that excel thinks has been used.
D
Dave Peterson
In the .find statement
..., After:=activecell, ...
or specify whatever cell you want to use.
..., After:=activecell, ...
or specify whatever cell you want to use.
B
Btobin0
you have a period at the end of used range. is there more to it?
B
Btobin0
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"
activesheet.used range. How do I set this up?
Workbooks.Open Filename:= _
"http://total." & Sheet1.Range("a1") & "." & Sheet1.Range("A1") & ".htm"
D
Dave Peterson
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.
same thing as Edit|Find in code.
Maybe you could restate your question.
B
Btobin0
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.
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.
D
Dave Peterson
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?)
Workbooks.Open Filename:= _
"http://total." & activecell.value & "." & activecell.value & ".htm"
(Did you really want that value duplicated?)
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.
B
Btobin0
unfortunately, that is how the web content was setup. not my choice, I just
have to work with it.
have to work with it.