Search:

Type: Posts; User: geofrichardson; Keyword(s):

Page 1 of 14 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    23
    Views
    685

    Hi verad Do you mean a continuous range as in...

    Hi verad
    Do you mean a continuous range as in Shift+Click or discontinuous with control +click?

    If a continuous selection then what about something like this as something different.
    You pas in...
  2. Replies
    3
    Views
    266

    [SOLVED] Hi Danci007 What happens if you put the...

    Hi Danci007

    What happens if you put the bookmark name in place of A1 in the conditional portion?

    Something like
    {IF BkmkName= " " "Until resignation" {A1} }
    or
    {IF BkmkName= " " "Until...
  3. [SOLVED] Hi Paul Oops, a critical misread of the original...

    Hi Paul
    Oops, a critical misread of the original post.
    I will delete the post.
    Geof
    :mad:
  4. Replies
    3
    Views
    145

    [SOLVED] Enable Old Pivot table Wizard ?

    Show Office 2003 Pivot Table Old Wizard

    Can you do this in Excel 07


    Right Click in PT
    Select Pivot Table Options
    Choose the Display tab
  5. Replies
    3
    Views
    145

    [SOLVED] Change Data Source

    Hi

    Excel 2010
    You would look for the contextual tab Named "Options" under the "PivotTable Tools" .
    On there you will find a button named "Change Data Source".

    45151

    Geof
  6. Hi Chuck You will have more joy customising the...

    Hi Chuck
    You will have more joy customising the ribbon.
    I believe that MS deliberately limited the QAT to the limits you have highlighted.
    Geof
  7. Hi Sorry but I am in the same boat as you....

    Hi

    Sorry but I am in the same boat as you.
    And I have my head in the hunny jar reflecting on judgement. I am going down to the creek to toss sticks and think some more.
    Geof
  8. Hi Does this article...

    Hi
    Does this article help?

    Geof
  9. Hi CWBilow Is that folder listed as the Excel...

    Hi CWBilow
    Is that folder listed as the Excel Startup location listed in Trusted locations?

    In my 2013 I see locations for a default User Startup and an Excel Startup.

    My Excel Start up is...
  10. Hi Zeddy I was surprised to read that some...

    Hi Zeddy

    I was surprised to read that some thought it was associated with layout and pagebreak views. I don't recall that but I cant refute it either.

    As far as I can remember extend mode was...
  11. Hi again The code below will only operate on...

    Hi again

    The code below will only operate on the two sheets, m1 and m2 shown in the screenshot.
    Each of the sheets m1 and m2 are activated in turn and the value 100 is inserted into "A30"
    45085...
  12. Extending selection with F8

    Hi
    It sounds to me as if you have (inadvertently) activated "Extend Mode" in excel.
    This is done by pressing "F8". Having done so the selection is extended to the next cell you click on.
    Look that...
  13. Hi Do you need activesheet.UsedRange .. If so...

    Hi
    Do you need activesheet.UsedRange ..

    If so then you might have to activate the sheet first


    Application.ScreenUpdating = False
    Sheets(sheetName).activate
    LastRow = activesheet.Usedrange...
  14. Replies
    1
    Views
    145

    USB Thumb Drive Failure

    Hi
    A friend asked me to check out the thumb drive.

    Disk manager shows it with a status of "No Media".
    Same report in multiple windows machines.

    I fear it is totally jiggered. Am I correct?
    ...
  15. Replies
    22
    Views
    916

    Validations

    Hi Zeddy et al

    This is my attempt to address the shortcoming that Zeddy identified whereby replacements were not context sensitive. This meant that the colour red would update in both the colour...
  16. Vlookup notes

    Hi Fishunt

    Welcome to the world of the balding.

    A bit of background on Vlookup()
    By design only 3 of the 4 arguments :- target, Lookup table, and column position of desired data are required....
  17. Hi I sometimes find it easier to get things...

    Hi
    I sometimes find it easier to get things working chunk by chunk.
    Try this after changing tweetyBird's email address.


    Sub sendEmail()
    'skeleton test script from Excel vba
    Dim oApp As...
  18. Replies
    22
    Views
    916

    Updating validated cells ver 2

    Hi
    Changes made include

    Cycling through the Validated Cells collection. No longer using .UsedRange.
    Using 2 validation sources in the Lists sheet.

    It should operate more quickly now....
  19. Replies
    22
    Views
    916

    Hi Fred The empty sheet was only there to check...

    Hi Fred
    The empty sheet was only there to check for bugs if sheet was empty. It is not required at all. I forgot to delete it.

    I cant get it to reliably mark invalid data with circles if I play...
  20. Replies
    22
    Views
    916

    Updating Validations

    Hi folks
    The attached workbook is my attempt to automate the updating of validated cell contents in the event that you edit the validation source list.
    I have used an Indirect() function against a...
  21. Replies
    22
    Views
    916

    Hi again Dynamic Range Names & use of Offset()...

    Hi again

    Dynamic Range Names & use of Offset()

    Are there advantages to this function over the use of a range converted to a table?

    A Data Validation rule could reference a table name instead...
  22. Replies
    22
    Views
    916

    Hi folks Thank you .. every day is a school day....

    Hi folks
    Thank you .. every day is a school day.

    activesheet.circleInvalid is indeed new to me.

    Geof
  23. Replies
    8
    Views
    367

    Hi Wayne In a spreadsheet it is possible to...

    Hi Wayne
    In a spreadsheet it is possible to suppress the view of rows or columns. In doing so the data and relationships are preserved.
    Hide a column
    Easiest way to hide a column is to right-click...
  24. Replies
    8
    Views
    367

    Hi Wayne Are you able to introduce an extra...

    Hi Wayne
    Are you able to introduce an extra column into the model as in attached screenshot? In this scenario the formula is in C1 and I would hide the intermediate column B.

    But what happens if...
  25. Replies
    22
    Views
    916

    Updating validated cells

    Hi folks
    I started playing as a learning exercise.
    Is there any merit in the following approach?
    This is not offered as a solution but more for comment as part of my learning. There will be bugs....
Results 1 to 25 of 329
Page 1 of 14 1 2 3 4