Hi all
Am creating a user sheet where date is entered in three different cells from data validation lists as Year, Month and Day, e.g. 2012, 2 and 13
Using concatenate I generate a date string as 2012 & "/" & 2 & "/" & 13 -à 2012/2/13.
Using match I am trying to find the row in column A (dates from 2008 to 2013) corresponding to the same date. Issue is that "A value is not available to the formula or function". I know that it is because my concatenated string is not recognised as a Julian number, but I have not been successful to fix it.
Advice, anyone?
Regards
Paul
[Non-text portions of this message have been removed]
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar