Re: Data Validation

Tech-Archive recommends: Fix windows errors by optimizing your registry

To both Gord and Dave,

I've tried it and it works! I didn't think about naming a range. I
didn't realise that you could name a range rather than an individual
cell.

Thanks for the tip regarding rows for named ranges.

This now does exactly what I want without any clumsy copying of data.

Thanks a lot!

Grateful John.

.

Relevant Pages

  • Re: OT. Favorite Sad Song
    ... over and over again till both of my young boys would just roll their eyes ... and then have a party. ... Thanks for sharing that Dave ... (Gord wrote so many it's hard to pick just one. ...
    (rec.arts.mystery)
  • Re: Delete Hard Return; Special Character
    ... Gord and Dave, you are 100% correct! ... this case, it's the Selection. ... In Excel, the characters look like a small square, and when copied and pasted ...
    (microsoft.public.excel.programming)
  • Re: Help Calling Pix With Macro-Affects All Pix on Sheet
    ... It's got to be something simple...am I naming incorrectly? ... "Dave Peterson" wrote: ... > Then you can loop through all the pictures and hide just the ones you want. ... > Private Sub Worksheet_Calculate ...
    (microsoft.public.excel)
  • Re: Lost the blue title bar on top of Excel 2003 workbook
    ... Bob, Gord, and Dave: Thanks for your replys! ... Bob, the F buttons on my Logitech keyboard do not have functions assigned to ... So, no, Gord, it didn't fix it. ... name of the workbook, or move the workbook around in the window. ...
    (microsoft.public.excel.misc)
  • Re: Password Protected Excel Spreadsheet opens blank
    ... Gord & Dave, ... If this doesn't work try to re-register Excel ... Opening it in Read Only Mode. ... Dave Peterson ...
    (microsoft.public.excel.setup)