troubleshooting Question

Would like a Macro that would use a dialog box to ask which column to use and than what number (value) to copy down what ever number of rows there might be.

Avatar of Dan Purcell
Dan PurcellFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelVBA
19 Comments2 Solutions125 ViewsLast Modified:
I have regular jobs where I get a number of excel address lists that I open, go to the last column, place the word List on the header cell, then copy a number (same number) down the column to the last row with data. The first list would be 1, the second list 2 and so on. The column isn't always the same so what I would like is a Macro that would open a dialog box asking me the column letter which I would enter, then ask me what number I'd like to use, then have it copy that number automatically down the column to the last active row. How that makes sence.

Thanks in advance
Roy Cox
Group Finance Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros