Solved

How to change macro to enter date in cell After it runs?

Posted on 2013-10-29
2
209 Views
Last Modified: 2013-10-29
I need to add to a macro that I have. When the macro runs I need it to put today's date in the same Row that it updated an account in Column AF.
Example- Run macro > it puts a Letter in column A and places a date in column AF.
I have attached a file with the macro code inside it.
Thanks,
Jimi
03-City-Non-Pay-WIP-TEST.xlsm
0
Comment
Question by:Jimi Sherman
2 Comments
 
LVL 12

Accepted Solution

by:
Harry Lee earned 500 total points
Comment Utility
Can you check if this is what you want?
03-City-Non-Pay-WIP-TEST.xlsm
0
 

Author Closing Comment

by:Jimi Sherman
Comment Utility
PERFECT!!
Thanks Harry
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now