-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
searchrange.offset
-
M
SearchRange.Offset, deleting row
after performing the below, i want to be able to delete the row on the sheet "database" and shift the data up one row so it isn't empty row there, and for the life of me no matter which way i try it i end up clearing the entire sheet Any guidance would be appreciated lastRow =...- mrkambo
- Thread
- a.endxlup.row ans lastrowa.value row searchrange.offset
- Replies: 3
- Forum: Excel Questions
-
M
Unsure on how to loop SearchRange
The code below works fine and does exactly what i want it to do, however what is the best way to loop it Sheet "New" has approx 3000 lines of data, the code below finds the first instance of SC which in this argument is 999, after its copied those values to "Database" how can i get it to...- mrkambo
- Thread
- 1.value debug.print lastrowd.value searchrange searchrange.offset
- Replies: 5
- Forum: Excel Questions
-
M
Search Function
Hi Im struggling to understand why this doesn't work, could someone take a look and advise please On Error GoTo error Dim SearchString As String Dim Lastrow As Long Dim ans As String Dim SearchRange As Range Dim Lastrowa As Long Const prefix As String = "COLL" ans = TextBox1.Value...- mrkambo
- Thread
- ans dim lastrowa.value searchrange.offset string
- Replies: 2
- Forum: Excel Questions
