M
MichaelDavid
Greetings! I would like to select column H on a worksheet so that I can
search for specified values in Column H. When I click on the column H Header
("H" at the top of the worksheet), all of column H is selected as expected.
I then wrote the following macro to select Column H:
Sub FindCloseDate()
' FindCloseDate Macro
' Keyboard Shortcut: Ctrl+l
Columns("H:H").Select
End Sub
When I execute this macro, all of columns A through O are selected. The
worksheet is somewhat irregular in that I believe it contains some merged
cells. I am not sure how to include the actual worksheet in this post. I
would like some way of simulating, via an Excel macro, the manual selection
of column H on the worksheet such that only column H is selected. Any help or
suggestions will be greatly appreciated.
--
May you have a most blessed day!
Sincerely,
Michael Fitzpatrick
search for specified values in Column H. When I click on the column H Header
("H" at the top of the worksheet), all of column H is selected as expected.
I then wrote the following macro to select Column H:
Sub FindCloseDate()
' FindCloseDate Macro
' Keyboard Shortcut: Ctrl+l
Columns("H:H").Select
End Sub
When I execute this macro, all of columns A through O are selected. The
worksheet is somewhat irregular in that I believe it contains some merged
cells. I am not sure how to include the actual worksheet in this post. I
would like some way of simulating, via an Excel macro, the manual selection
of column H on the worksheet such that only column H is selected. Any help or
suggestions will be greatly appreciated.
--
May you have a most blessed day!
Sincerely,
Michael Fitzpatrick