Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

store unlocked cells in a range

Status
Not open for further replies.

wmbb

Technical User
Jul 17, 2005
320
NL
What is the easiest way to store all unlocked cells in a range so I can use this range in macros.
I tried to loop all cells to find a unlocked cell and subsequently add this cell to a var using var = var & (,) & foundcell.Address, but takes a long time. Is there a faster way to do this ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top