Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Macro Class 4 - how do I copy specific columns (1,3,5) instead of an entire row?

0

Hi Macro Class 4 looks like the ideal fit for my project. How do I specify certain columns (e.g., 1, 3, and 5) instead of entire.row?

excelmacros-vba
MS Office Version: 2013
posted by: sumjoy2020 (rep: 2) on Sun Jun 14, 2020 at 11:21 pm
Answer
Discuss

Answers

0
Selected Answer

That depends on the specific code that you are talking about, but if you want to refer to an entire column, you could do it like this:

Range("A:A").Select
Range("A:A, C:C, E:E").Select

Replace .Select with what you want to do with the columns.

posted by: don (rep: 1989) on Mon Jun 15, 2020 at 2:54 am
Discuss

Discussion

Thank you, I will give this a try.
sumjoy2020 (rep: 2) Jun 17, '20 at 8:22 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login