I'm trying to write a macro for Excel. Here's what I'm trying to do. I have a list of 25 rows of data. I want to copy one row, paste it in another, and then print another worksheet to PDF (and then repeat with the next row). I can only get as far as printing to PDF. It keeps prompting me for a file name, when I actually want it to save the file as a cell value. Any advice?
guinness281 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.