many columns, A column is date , if Axx cell equal a date, then select a data range in B column to calculate a function.
how to select that range?
Thank you so much
many columns, A column is date , if Axx cell equal a date, then select a data range in B column to calculate a function.
how to select that range?
Thank you so much
Your post is quit lacking in clarity or enough detail to provide an accurate response. What do you want to accomplish with column-B?
If IsDate(Range("A1")) And Range("A1") <= Date Then Range("B1:B10").Select 'other code End If
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks