Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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.
0
carlosab
Asked:
carlosab
  • 4
  • 3
1 Solution
 
Saqib Husain, SyedEngineerCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now