Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
I need something more dynamic like this.
Range("A2").AutoFill Destination:=Range("A2:A" & LastRow)
That will not work because the column property of the active cell returns a number, not a column letter. I maybe could try to convert the number to a letter, but it gets complicated after the letter Z.
ActiveCell.AutoFill Destination:=Range(ActiveCell.Address & ":" & ActivceCell.Column & LastRow)
|VBA code to open new email message (Contact Us)||3||32|
|Data in Rows to be converted into single row||9||39|
|excel 2010 - Formatting Text in a cell to capitalize without using UPPER function||12||37|
|Excel conditional formatting based on 'zero value'||6||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!