Answered step by step
Verified Expert Solution
Link Copied!

Question

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 to Expert-Tailored 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

Recommended Textbook for

An Introduction To Wavelet Theory In Finance

Authors: Francis In, Sangbae Kim

1st Edition

9814397830, 978-9814397834

More Books

Students also viewed these Finance questions

Question

Relational Contexts in Organizations

Answered: 1 week ago