Select until last row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Select until last row

08-12-2022, 01:28 AM

Marcia

Windows 10 Select until last row

Office 2019

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Select until last row

Hi. This code selects the range A5 to AQ50. I would like the code to select only the rows from A5 until the last row of a dynamic pivot table.

Code:

Dim lr As Long
    Range("A5:AQ5" & lr).Select
    Selection.Copy

What should the line be?
Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select entire text and then de-select certain Headings?	tq94	Word	3	02-26-2022 03:47 AM
select paragraphs	yacov	Word	2	10-25-2020 02:53 AM
How to select the end of a document?	ArtKilp	Word VBA	2	06-15-2020 06:44 PM
Select a row in a different tab	cosmicyes	Excel Programming	1	07-09-2018 02:47 AM
How to select row	aymanharake	Excel Programming	3	02-18-2017 04:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:04 AM.