Replies

My understanding is that you can’t do a “begins with” filter on numbers, as “begins with” is a string comparison. If you want to filter on all the numbers starting with 299, then I would suggest filtering on “>=290000 and <300000".

Jon

The options that I know about are:
1) somebody else has it open,
2) you have another instance of Excel open on your machine, 3) you have had an Excel crash (GPF etc) and the file thinks you still have it open.

Have you tried a reboot?

Jon

Maybe I’m simple (ok, definitely), but I’d just create a column with =Rand() in as many cells as I needed random numbers. If I didn’t want them to change every time recalc happened, I’d do a copy/paste values.

Is that what you are after, or am I missing something?

Jon

At a guess it sounds like a network rights issue. When you say that the coding does not work, what error messages do you get? Are the VBA and worksheets all in the same workbook, or is the VBA in an xla?

Jon

SNAP!

If you have data validation on a range (see Validation under the Data menu), then you can copy and paste just the data validation settings without any thing else by using Copy and Paste Special Validation.

Jon

My only thought is that you can do it in VBA, with a subroutine along the lines of

sub SortSheet()
worksheets(1).unprotect password:=???
range(“a1:b500”).sort key1:=range(“a1”)
worksheets(2).protect password:=???
end sub

What I would suggest is that you record the macro, as the recording for a simple job like this will be fine.

Sing out if you need further help.

Jon