Thread: Fill a column in a worksheet from a formula worksheet based on the date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Fill a column in a worksheet from a formula worksheet based on the date
try

mm=1

--
Don Guillett
SalesAid Software

"NadiaR" <u19707@uwe wrote in message news:5d4f684c6ea9e@uwe...
I tried this but it did not work, I need it to start at January...any
suggestions?

NadiaR wrote:
Hi Don,

do I apply what's below to my current VB? or do I delete everything I have
and use yours?

thanks so much

This should work for the current month from anywhere in the workbook. It
will not work for March if you wait until April but you can change the mm
[quoted text clipped - 17 lines]

End Sub


Reply With QuoteReply With Quote