Is it possible to return the number of rows the following code would select. The selection is then to be pasted into another sheet and i need the number of rows so that i can paste a formula, say in row B1 for the same amount of rows.
Range("A1".Select
Selection.Copy
Range(Selection, Selection.End(xlDown))
cheers.
Range("A1".Select
Selection.Copy
Range(Selection, Selection.End(xlDown))
cheers.