ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Range("Y1:Y" & LastRow & "&") (https://www.excelbanter.com/excel-programming/432479-range-y1-y-lastrow.html)

LuisE

Range("Y1:Y" & LastRow & "&")
 
What is the correct way to put the variable and the quotation after it?

Thanks in advance

[email protected]

Range("Y1:Y" & LastRow & "&")
 
LuisE wrote:

Range("Y1:Y" & YourCell.Row)


What is the correct way to put the variable and the quotation after it?

Thanks in advance


Peter T

Range("Y1:Y" & LastRow & "&")
 
Range("Y1:Y" & LastRow)

quotation after it?


don't do that <g

Regards,
Peter T

"LuisE" wrote in message
...
What is the correct way to put the variable and the quotation after it?

Thanks in advance





All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com