Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting search range from VBA
I have the following to find the last cell used
myrow = range("sheet1!S65536").END(xlup).row + 1 I then need to search in cells based on the last cell found or each cell in range(z3:zx") 'x = myrow above if len(trim(cell.value)) < 1 then count = count + 1 next cell range("a1").value = count How can i pass the myrow value so i can make it my range for search from z3 to z(myrow) ? thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up Excel to search by columns instead of by rows, by defau | Setting up and Configuration of Excel | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Search Range for item in seperate range | Excel Programming | |||
setting range().hidden=True causes range error 1004 | Excel Programming | |||
How to search a range for a suburb in a large range | Excel Programming |