Select visible cell before a particular cell

[ks1987]

Hi,

I am writing a VBA code, where I need to copy the visible cell before AF53 from multiple files and paste them in another file. For that I need to figure out how to select the particular cell as it may be in different columns in one or the other file

Thanks in advance

 

[jeffmb]

You can loop backwards from column 32 (AF) to find the last visible cell. The syntax would be:

Sub Find_Visible()
Dim i As Integer
    For i = 31 To 1 Step -1
        If Columns(i).EntireColumn.Hidden = False Then
            ' Your Code Here<YOUR Code>
            Exit For
        End If
    Next
End Sun