Finding closest value in a column
I tried using:
x=vlookup(strStartDatumArray(1); rng(1); rng(1); False)
where straStartDatumArray(1) contains the date that I want to find. I want
to find it below the cell rng(1) and I want to return that very value
(rng(1)). rng(1) is a position in an array that is given like this:
rng(k)=Worksheets(varWorksheetInfoArray(0)).Cells.Find(varWorksheetInfoArray(k), LookIn:=xlValues)
If you have any idea how to make my code work I would be most grateful for
your assistance! Thank you very much!
vlookup
Hot Topic
- Unable to infopath form in browser
- use inputbox to choose cells for plots in excel
- ASP .NET 1.1 fails at install, but not .NET Framework 1.1
- Registration Limits and Useage Rules
- Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
- DOS Command Question
- Text file search, return data from line other than search string line
- Workbooks.Open (... problem
- Want to shell(myprogram)...
- Can you use VBA to access a spread sheet embedded in a word doc?
Microsoft ISV
- How to judge a field's value is already exist while inputing it?
- Select/cut/insert
- Setting the Directory at GetOpenFileName
- Unable to create .NET class in VBA
- Compatibility Issue Excel 2000 and Excel 2003
- # recipients, subject, body of a Mail not recognised
- Link to Lotus Notes Document through Excel
- CRM 3.0 Outlook Client
- Databases comparison
- add a digital signature to a document without displays the Signatures dialog box?
vlookup
nobs411
Since you haven't gotten a response yet, try asking the Excel
specialists in the Excel programming newsgroup, here:
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.ex
cel.programming&lang=en&cr=US
<http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.e
xcel.programming&lang=en&cr=US>
-- Cindy (Word MVP)