Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Year question
I am having problems working out a simple little sum. I have a userform
when I have a new member join I want it to add the current year. How can I get excel to do this the easy way. I currently have it paste the now() value and have set the cell to show yyyy but unfortuantely when I go to the next cell where I want to have the worksheet work out the years member section it comes up as volitile. Any Ideas Thanks Greg |
#2
|
|||
|
|||
Year question
Hi Greg,
With Range("A1") .NumberFormat = "General" .Value = Year(Date) End With Change A1 to the cell of interest. --- Regards, Norman "Greg B" wrote in message ... I am having problems working out a simple little sum. I have a userform when I have a new member join I want it to add the current year. How can I get excel to do this the easy way. I currently have it paste the now() value and have set the cell to show yyyy but unfortuantely when I go to the next cell where I want to have the worksheet work out the years member section it comes up as volitile. Any Ideas Thanks Greg |
#3
|
|||
|
|||
Year question
Hi, I'm not an expert but maybe something like this in your code: Activecell.Formula = Year(Now()) HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=482391 |
#4
|
|||
|
|||
Year question
Thanks Norman work great
Greg "Norman Jones" wrote in message ... Hi Greg, With Range("A1") .NumberFormat = "General" .Value = Year(Date) End With Change A1 to the cell of interest. --- Regards, Norman "Greg B" wrote in message ... I am having problems working out a simple little sum. I have a userform when I have a new member join I want it to add the current year. How can I get excel to do this the easy way. I currently have it paste the now() value and have set the cell to show yyyy but unfortuantely when I go to the next cell where I want to have the worksheet work out the years member section it comes up as volitile. Any Ideas Thanks Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Auto Year scale | Charts and Charting in Excel | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
leap year question | Excel Discussion (Misc queries) | |||
Weeknum Year by Year Compare | Charts and Charting in Excel |