Question: how to use xldown in vba?
Answer: End(xlDown) is the VBA equivalent of clicking Ctrl + Down . This will give you an idea of all the different rows, Ctrl + Down might take you to. Set newRange = ws. Range("A1").