Re: $$Excel-Macros$$ Problem assigning a function to a variable

Change 16 to 15 On 05-Jun-2016 3:50 AM, "Laura Wheaton-Werle" < la...@doublewcommunications.com> wrote: > I've created a simple VBA code that copies a line of code to a specified > range. > > Sub PowerOfOne_Report() > > ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:3").Copy > Act

$$Excel-Macros$$ Problem assigning a function to a variable

I've created a simple VBA code that copies a line of code to a specified range. Sub PowerOfOne_Report() ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:3").Copy ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:16").Select ActiveSheet.Paste End Sub HOWEVER, I need to