Target range in macro is too long?

[theskeptic99]

Hello,

I have an Excel macro (Thank you forum users!) that will lock cells after data has been entered and saved. It works beautifully, but recently, I have created a spreadsheet where there are hundreds of cells that need to be protected after they have been populated. The problem is that the cells are non contiguous and when I try to type in the cell range, the line of code becomes too long and stops working. Is it possible to split this range into two or more lines of code? Or can I apply the same macro to the same Excel tab twice, with the first macro protecting the first 200 cells (for example) and the second macro protecting the last 200 cells? Thanks in advance!

[TMS]

Post your code. It might be as simple as using underscore ( _ ) to break the line. Or you could define two or more ranges and then use Union to join them together.

Regards, TMS

[theskeptic99]

Thanks for the reply! The specific line of code is:

"ActiveSheet.Range("A1:B4,D1:E4,G1:H4,A6:B10,D6:E10,G6:H10").Select"

For simplicity, I just wrote 6 cell ranges here, but in the spreadsheet that I am working on now, there are over 100.