Writing VBA macro for generating missing variable

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,040
Office Version
365, 2010
If you modified the existing macro, post your version now and I'll show you how to place the headers on.

Basically, from my original macro, you want to use something like:

Code:
Cells(7, 1) = "Hobbies"
Cells(7, 2) = "Candidate"
Always happy to help!

Kevin
 
Last edited:

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

ryan8200

Active Member
Joined
Aug 21, 2011
Messages
299
If you modified the existing macro, post your version now and I'll show you how to place the headers on.

Basically, from my original macro, you want to use something like:

Code:
Cells(7, 1) = "Hobbies"
Cells(7, 2) = "Candidate"
Always happy to help!

Kevin

Thanks for the help. How to amend the code so that the output will be displayed at new worksheet instead of existing worksheet
 

Watch MrExcel Video

Forum statistics

Threads
1,099,516
Messages
5,469,097
Members
406,635
Latest member
jfhunter64

This Week's Hot Topics

Top