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.

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 02:41 PM.