specifying range based on input

G

Guest

In my continuing effort to figure out how to specify FY ranges in a
spreadsheet, I have made some progress. However, what I have come to is an
input statement to specify which date shall be used as a starting point for
the range.

My problem now, is that I need to be able to take the input (mybegdate) and
get the code to select the cell corresponding to mybegdate so the
currentregion can then be identified.

Thanks.
 
K

keepITcool

Excel has a inputbox method for that.
(it's different from vba's standard inputbox method,
so be sure to precede with application...

See VBA help.. but for a range you need Type:=8


dim rng as range
set rng = application.inputbox("Select the date",Type:=8)

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
G

Guest

I have an input that works.
What I have is a bunch of dates in column A. I need Excel to select the
cell in column A that corresponds to the input date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to determine where input goes 2
Copy range based on input 1
Copy named range based on variable 2
Print Non-Contiguous Ranges From User Input on All Worksheets 4
Selection based on partial input 1
Print Macro Function 1
How to add one column to a range VBA 4
Excel 2 into 1 6

Top