Apologies if this has been answered before, but I searched multiple forums and did not find a response that was adequate and/or solved my current problem.
I am in the process of trying to code a Macro for converting text to numbers on 2 separate worksheets (see example below)
Sheets("SDP LW").Select
Cells.AutoFilter
Range("A3").Select
Range(Selection, Selection.End(xlDown)).Select
With Selection
Selection.NumberFormat = "General"
.Value = .Value
End With
Sheets("SDP YTD").Select
Cells.AutoFilter
Range("A3").Select
Range(Selection, Selection.End(x1Down)).Select
With Selection
Selection.NumberFormat = "General"
.Value = .Value
End With
The first part goes smoothly and for the second part, I get a debug pop up and the "Range(Selection, Selection.End(x1Down)).Select" portion of the code is highlighted. When I right click on the highlighted portion, I get the message "Cannot jump to range because it is hidden".
Any ideas for updating the code so it runs would be greatly appreciated.
Bookmarks