VBA coding in Excel

I need some code that will insert today's date in each row in Column H if there is a value in that row in Column G. Thanks.
carlosabAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
If column H has all values and not formulas then you can try

Range("G:G").SpecialCells(xlCellTypeConstants).Offset(, 1).Value = Date
0
 
carlosabAuthor Commented:
Awesome. Thanks.
0
 
[ fanpages ]IT Services ConsultantCommented:
Less typing! ;) ...

[G:G].SpecialCells(2).Offset(, 1) = Now

Seriously, though, impressive response ssaqibh! :)
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Saqib Husain, SyedEngineerCommented:
Just a wee bit late. You could have won it.
0
 
[ fanpages ]IT Services ConsultantCommented:
Better late than pregnant.
0
 
Saqib Husain, SyedEngineerCommented:
I wonder what is going to happen at your pace :)
0
 
[ fanpages ]IT Services ConsultantCommented:
A "(Comment deleted by Moderator)" message, probably.
0
 
Saqib Husain, SyedEngineerCommented:
:D
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.