Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

What the below code does? lc = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row Dynamic_Range = Range(Cells(1, lc + 2), Cells(lr + 5, lc + 20))

What the below code does? lc = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row Dynamic_Range = Range(Cells(1, lc + 2), Cells(lr + 5, lc + 20))

1- Specify an area (to put a graph, for example) 2 row below the data table 2- Specify an area (to put a graph, for example) 2 row above the data table 3- Specify an area (to put a graph, for example) 5 row below the data table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions