Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Subscript out of range
#4
Solved: 11 Years, 3 Months, 3 Weeks ago
As an alternative you can use the built in date functions.
Code:
mydate = "6/12/10 10:23 AM"
mymonth = Month(mydate)
myday = Day(mydate)
myyear = Year(mydate)

msgbox "Month: " & mymonth &vbcrlf & "Day: " & myday & vbcrlf &  "Year: " & myyear

No need for multidimensional arrays then.
Reply


Messages In This Thread
Subscript out of range - by vijayendra.shukla - 06-11-2010, 04:55 PM
RE: Subscript out of range - by guin.anirban - 06-11-2010, 06:51 PM
RE: Subscript out of range - by vijayendra.shukla - 06-11-2010, 07:40 PM
RE: Subscript out of range - by jsknight1969 - 06-11-2010, 09:05 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to count a repeated number in number in particular range gollsrin 1 3,571 04-28-2011, 11:41 AM
Last Post: Saket

Forum Jump:


Users browsing this thread: 3 Guest(s)