mmm

Hi everyone, I am very new to Marco, it would be glad to get some help here :) Here is my trial: DD = Day(Date) MMM = Month(Date) YY = Year(Date) WBK = "S:\Project" & Format(Now, "DD MMM YY") & ".xlsx" Windows("Destination File.xlsx").Activate...

Hello Excellers! How can I make a cell values appear in all caps? I have the following formula in several cells: =DATE($U$1,COLUMN()-2,1). The cell is formatted to show just the month abbreviation: "mmm". Basically the cell just shows the month (Jan, Feb, etc.) but other cells reference...

Hello! i'm trying to write a piece of code in VBA but have encountered some issues. below you can see my code. But the formula doesn't work without the "" around MMM but if i try run the code i get the area as excel is trying end the formula. How do i get around this? Worksheets("Source...

I'd like to turn this formula = "pour " & TEXT(StartDate1, "MMM d, yyyy") & " à " & TEXT(EndDate1,"MMM d, yyyy") into VBA code. However, the code is part of a loop and each date increments. I was using dtStartDate as the variable for each start date that was reset at the beginning of each...

My workbook has several worksheets, each with some Date columns displaying format dd mmm yyyy. However if I click in the date cell, the formula bar shows dd mm yyyy - in all but one of the worksheets. Yet looking at the cell format all are set the same - to Custom dd\ mmm\ yyyy. (That also...

Hello excel friends, I have an issue trying to make a button to send an email containing a PDF of a certain range on a certain sheet. The purpose is to send the worksheet to others, so that they can then fill in the sheet and send the information that i want from them back to me by simply...

I'm connecting to Excel 2003 from Access 2007 to populate a worksheet created by a 3rd party program. From Access I send xlSh.Cells(iRow, 11).Value = Day(Now) & " " & MonthName(Month(Now), True) & " " & Year(Now) This should result in dd mmm yyyy but Excel shows this as dd-mmm-yy I guess...

Hi, I have a table in a worksheet and a userform that colects the data from the table using vlookup, if i change the data on the userform how can i send it back to the table just using the userform???????? Here is what i have so far Private Sub ComboBox1_dropbutt*******() On Error Resume...