Hi,
I have this code but I am getting a type mismatch error message:
yr = 2014
mth = "Mar"
mth_value = Month(mth & 1)
mth = Text(Date(yr,mth_value,1),"mmmm")
I know that this is a formula in a worksheet but I need to assign this as value.
Hi,
I have this code but I am getting a type mismatch error message:
yr = 2014
mth = "Mar"
mth_value = Month(mth & 1)
mth = Text(Date(yr,mth_value,1),"mmmm")
I know that this is a formula in a worksheet but I need to assign this as value.
There is no Date or Text function in VBA.
The equivalent of those worksheet functions are DateSerial and Format, though if you change the code to use those functions it will still error.
What are you trying to do with the code?
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks