identify weekend in VBA 7

[NiteCrawlr]

How can I make a VBA code in Excel that identify weekends in a Date type cell. When it identify a weekend I want it to change the color of the whole line.

Help please,
TKS

Nite

 

[hjgoldstein]

Thanks guys. Your expertise astounds me.

I've managed to sort this out using a mixture of your suggestions.

I'll join you in if you'd welcome an outsider!

 

[xlbo]

And the star goes to Bowers74 or Beniez ????

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[xlbo]

and I've just realised that when I was referring to NiteCrawlr, it should've been hjgoldstein

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Bowers74]

Just one more tip regarding Geoff's comment

"Problem is that the little udf isn't much code but it WILL require macros to be enabled for it to work":

If you use the functions, you can put them into a seperate workbook and save that workbook as an Add-in. If you have the Trust all installed add-ins and templates under Tools->Macro->Security... in the Trusted Sources tab, after installing the Add-In you won't be asked to Enable Macros.



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[xlbo]

Good tip Mike - have a star for that alone but as a side note, you then have to make sure that the users know how to install add-ins ;-)

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Bowers74]

Which can sometime be more difficult than writing the code. ;-)

Thanks for the star!

I don't think goldsein is coming back. He unmarked the thread. Oh well, I guess we'll never know who helped him. :-(

At least he got the help he needed, right?

Had one left from yesterday.



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[xlbo]

[L O L] - darn tootin' Mike
Time for this thread to die methinks

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244