Move Cursor to a Specific Cell

[dp724]

I have a worksheet filled with link formulas, which will be used to importing data to Access. I'd like to set up a macro which clear certain cell contents. How can I make the cursor move to the last cell of a row, which has a value greater than zero? At the moment I can only make it move the last cell with a formula.

Thanks in advance.
Dave

 

[Scott Huish]

Why do you need to select the cell? Don't you just want to clear cells?
What cells need to be cleared?

 

[dp724]

Thanks for the reply. Basically, the macro will clear contents for a range which will always be different. But it sounds like you have experience with Access and the more I think about this macro idea, the more I'm starting to believe that I really need to somehow manipulate the data that gets imported in to Access. I'm still undecided. But can you tell me how can I make the cursor move to the last cell of a row, which has a value greater than zero?

 

[QuietRiot]

Sub Macro4()
Last = Range("A65536").End(xlUp).Row
    For x = Last To 1 Step -1
        If Cells(x, 1).Value > 0 Then
            Cells(x, 1).Select
            Exit Sub
        End If
    Next
End Sub

that is for column A

that work for ya? just change the "A65536" to whatever column A,B,C etc

then change the Cells(x,1) <--- 1 to whatever column 1=A, 2=B, 3=C

 

[Scott Huish]

Is this an Access question or an Excel question?

 

[dp724]

Thanks QuietRiot,
Works out perfectly! Only one change needed 'Cells(2, x)'.

Hotpepper,
Got my Excel question answered...thanks!