Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    7
    Views
    366

    Hi Howard ..now back at home. Did you check...

    Hi Howard

    ..now back at home.
    Did you check previous posting out?

    zeddy
  2. Hi Steve Another way could be to use formulas...

    Hi Steve

    Another way could be to use formulas and Excel's camera tool.
    see example attached.

    zeddy
  3. Replies
    7
    Views
    366

    Hi Howard ..the flight was OK, but next day I...

    Hi Howard

    ..the flight was OK, but next day I was admitted to hospital again. Internal gunk removed. Still here. Nothing major. More ops to come.
    Apologies for delay.

    I have attached an...
  4. Hi Mattock12 ..welcome to the Lounge! You...

    Hi Mattock12

    ..welcome to the Lounge!

    You just need to adjust your formula to subtract 1 if there are any "No DT" in the range, so use this:

    ...
  5. Replies
    7
    Views
    366

    Hi Howard ..oops! I just attached what the...

    Hi Howard

    ..oops! I just attached what the newest file (but from the wrong folder!)
    I did it again.
    ..here it is.

    leaving shortly!

    zeddy
  6. Replies
    7
    Views
    366

    Hi Howard I have modified your code slightly -...

    Hi Howard

    I have modified your code slightly - I'm sure you will see the changes I made.
    see attached.

    I added a Worksheet Activate routine for sheet [Br1]
    When you switch to sheet [Br1], the...
  7. Replies
    4
    Views
    238

    Hi Trying to preserve existing filters after...

    Hi

    Trying to preserve existing filters after 'refreshing' data can be unreliable depending on the type of filters you are using.
    For example selected ranges (xlTop10Items, xlBottom10Items,...
  8. Replies
    11
    Views
    342

    Hi Steve ..you were quicker than me, again. ...

    Hi Steve

    ..you were quicker than me, again.

    zeddy
  9. Replies
    11
    Views
    342

    Hi Kerry First of all, when using lookups or...

    Hi Kerry

    First of all, when using lookups or match, you must compare apples with apples, i.e. if your cost center value is 'text' in your extract, then it must match a text value in your source....
  10. Hi Martin I could tell from your accent. So...

    Hi Martin

    I could tell from your accent.
    So I'm assuming you're on the Trans-Siberian express.
    Didn't know they had wi-fi on that.

    zeddy
  11. Hi Martin ..why not just go to Leeds? (it's...

    Hi Martin

    ..why not just go to Leeds?
    (it's twinned with Ulan Baator)

    zeddy
  12. Thread: Table Headers

    by zeddy
    Replies
    2
    Views
    119

    Hi rvWoody You can hide specified dropdown...

    Hi rvWoody

    You can hide specified dropdown filter arrows using VBA as follows:



    sub hideMyFilter()

    [a1].currentregion.AutoFilter Field:=3, VisibleDropDown:=False '3=column [C] = third...
  13. Hi This is standard 'auto-correct' behaviour....

    Hi

    This is standard 'auto-correct' behaviour.
    In Excel 2007, typing three consecutive full-stops will be replaced by the single ellipsis character.
    If you want to turn this off, in Excel 2007:...
  14. Hi RG I took your xlsb file, deleted all the...

    Hi RG

    I took your xlsb file, deleted all the code, changed it to a .xlsx file, and just added another format rule to the data range.
    I toggled this rule to a cell setting (i.e. to make an ON /...
  15. Hi Farrukh See attached file for one method of...

    Hi Farrukh

    See attached file for one method of returning data based on matching the lookup entries in two columns.
    I combine the two columns into one lookup code on each sheet, in an adjacent...
  16. Replies
    4
    Views
    281

    Hi Tom, Steve & RG Many thanks for your...

    Hi Tom, Steve & RG

    Many thanks for your responses.
    I thought I might start with looking at what's on the left-hand side of any equals sign, as in..
    xxxxxxx = whatever

    ..and perhaps look at...
  17. Replies
    4
    Views
    281

    listing variables used in a vba routine

    Hi

    If I wanted to properly document a vba routine, I would find it very useful if there was a utility that could list all the variables used in each subroutine in a vba module. If everyone used...
  18. Hi RG re "Note: the ## are just because I...

    Hi RG

    re "Note: the ## are just because I didn't adjust the row width for large numbers"

    I know you meant 'column width'. So how about adding something like this :




    'We cannot just use...
  19. Hi Beryl ..have a look at the attached file....

    Hi Beryl

    ..have a look at the attached file.
    I added some columns to simplify things.
    The formulas are now simpler.

    If you have any questions, please ask.

    zeddy
  20. Replies
    15
    Views
    436

    Hi Maudibe ..heh heh. I knew you knew that....

    Hi Maudibe

    ..heh heh. I knew you knew that.
    ..I was waiting for Alan to discover that Font.ColorIndex = 1 is for black.

    zeddy
  21. Replies
    15
    Views
    436

    Hi ..you could use something like:...

    Hi

    ..you could use something like:
    rcell.Offset(0, 1).Font.ColorIndex = 3

    ..where 3 will give you Red

    zeddy
  22. Replies
    3
    Views
    197

    Hi Steve/Maudibe Many thanks for your...

    Hi Steve/Maudibe

    Many thanks for your suggestions. Top marks! I'll use both.

    In the existing version, the source was being copied using the Cells.Copy command.
    I had to include a vba section...
  23. Replies
    3
    Views
    197

    Replace a worksheet currently in use

    Hi All

    I have a worksheet [FRED] that is being referenced in formulas on other sheets.
    I would like to replace this entire sheet with a copy of another sheet, [MARY].
    I could just delete the...
  24. Hi My code searches for filenames that contain...

    Hi

    My code searches for filenames that contain the text entered in column [A], and the search results include the full path to the file.
    If more than one file is found that contains the specified...
  25. Replies
    6
    Views
    285

    Hi Steve Apologies for delayed response - I'm...

    Hi Steve

    Apologies for delayed response - I'm being re-admitted back to Hospital today. Ouch.

    Your efficient 'sort' solution is how I was originally thinking, but I was a bit muddled at the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4