Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My code inserts multiple columns in various places, adds some vlookup and
then selects the used range (which ends up to be Columns A-U, Rows A through 'varies each time'). I'm struggling with how to do the following: 1) Allow the user to enter any data they want outside of the used range (i.e., after the last row/column with an entry. 2) Protect Columns A:J and L:U (and their associated rows) in the used range from any data being entered, but allow the user to enter data anywhere in Column K (including the used range portion). Can anyone please help me with how to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protecting the Print Range. | Excel Discussion (Misc queries) | |||
Protecting a Range of Specific Cell/s | Excel Discussion (Misc queries) | |||
Protecting a Range of Specific Cell/s | Setting up and Configuration of Excel | |||
Protecting Range Names | Excel Discussion (Misc queries) | |||
Protecting Formulas from a range from being viewed | Excel Discussion (Misc queries) |