searching in a dynamic row range.

[banh]

Hi, I have this piece of code:

Please Login or Register  to view this content.

Right now it searching inside the range from row 26 to row 592. ( i am not sure if it is, just based on the code ) Thing is that i want it to search in a dynamic row range that is store in 2 variables that are going to change from time to time. But i am not able to do so.

I have tried .Row("range1:range2") with range1 and range2 as the two integers
I also tried .Range("range1:range2") with range1 and range2 as strings of "B"&26 and "B"&592

I am pretty new to macro VBA, please help. Does macro allows that? or do i have to do something different

Thank you.

[Mordred]

Hi banh and welcome to the forum. Please read the forum rules located here and wrap your code with code tags as per rule #3. Once you do that someone will be able to help you.

[banh]

Hi banh and welcome to the forum. Please read the forum rules located here and wrap your code with code tags as per rule #3. Once you do that someone will be able to help you.

Thanks for reminding me.

[Mordred]

Hi banh, would you be able to show your full procedure so that we can see exactly what is going on with regards to

Please Login or Register  to view this content.

&

Please Login or Register  to view this content.

By what you have submitted,

Please Login or Register  to view this content.

should be something like

Please Login or Register  to view this content.

but without seeing the rest of your code it is hard to ascertain whether that is the end all fix.

[watersev]

hi, banh, try this out

Please Login or Register  to view this content.

[Marcol]

I suspect as your rows can be variable you want to find the last row dynamically.

Please Login or Register  to view this content.

You could also control ColNo and FirstRow if we knew the conditions to work to.

[banh]

hi, banh, try this out

Please Login or Register  to view this content.

Thank you so much, I think that does it. Just for reference, I was trying to search the variable sText in a certain row range of thousands of items. I already know how to search for the starting row index and the ending row index but don't know the syntax to put it in the equation to find. Now I know, thanks so much, you save my life.

May I ask is there a site that contains all syntax information for things like this along with explanation like oracle has for Java? I have been looking everywhere online, all they have are just basic ones.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved. Please read all the Rules and don't use phraes like "Need help" in thread titles.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save