Home |
Search |
Today's Posts |
#1
|
|||
|
|||
accessing rows with macros
Hi,
I'm quite new to excel. I'd like to loop through all the rows in my sheet and compare the text in the cells of the first column with some string variable priorly set. How can I do that ? Also I would like to disable my cells for editing, so that only my function run when I click on a button can modify those cells. I've done it through protecting the sheet from editing, but then even my macro can't edit the cell without having to enter the password;) Thx |
#2
|
|||
|
|||
For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row If Cells(i,"A") = "somevalue" Then 'do something End If Next i -- HTH RP (remove nothere from the email address if mailing direct) "Sam" wrote in message oups.com... Hi, I'm quite new to excel. I'd like to loop through all the rows in my sheet and compare the text in the cells of the first column with some string variable priorly set. How can I do that ? Also I would like to disable my cells for editing, so that only my function run when I click on a button can modify those cells. I've done it through protecting the sheet from editing, but then even my macro can't edit the cell without having to enter the password;) Thx |
#3
|
|||
|
|||
thanks a lot , that works
|
#4
|
|||
|
|||
my pleasure
Bob "Sam" wrote in message ups.com... thanks a lot , that works |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |