Search:

Type: Posts; User: Paul Lautman; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    13
    Views
    1,672

    Which I posted above 2 days ago once I worked it...

    Which I posted above 2 days ago once I worked it out.
  2. Replies
    13
    Views
    2,805

    I think I was aware of that. Indeed immediately...

    I think I was aware of that. Indeed immediately following that post I posted:

    "I'll try that.I already use another_range_object.value = range_object.value which does the equivalent of Paste...
  3. Replies
    13
    Views
    2,805

    Bob's one doesn't work on a set of columns, only...

    Bob's one doesn't work on a set of columns, only on a single column and so doesn't work.
  4. Replies
    13
    Views
    1,672

    RetiredGeek, that article talks about using them...

    RetiredGeek,
    that article talks about using them in sheet formulas and if you looked at my workbook you'd see it was already working there. In fact the help link I supplied earlier gives more...
  5. Replies
    13
    Views
    1,672

    Bob: You said "However, your description did not...

    Bob:
    You said "However, your description did not mention that the ranges you created were LOCAL range names, only on sheet3."
    The very first line of the original post said "The attached workbook...
  6. Replies
    13
    Views
    1,672

    If you tried that in my workbook (which I...

    If you tried that in my workbook (which I attached to the OP) then I do not believe that you got an output.

    You can learn about the sope of range names by reading the help here:...
  7. Replies
    13
    Views
    1,672

    I did try that. Did you try it before posting? ...

    I did try that. Did you try it before posting?

    The referred to range may be located on Sheet1, but the scope of the range name is Sheet3. I was very careful to put this information in the OP.
    ...
  8. Replies
    13
    Views
    1,672

    You now have aaa defined at workbook level. In...

    You now have aaa defined at workbook level.

    In my original workbook I had 2 ranges defined with a scope of Sheet3.

    If I use a formula on Sheet3 of =aaa it correctly displayed the value of cell...
  9. Replies
    13
    Views
    2,805

    No because it pastes from the clipboard which...

    No because it pastes from the clipboard which violates the "without going via the clipboard" in the OP.
  10. Replies
    13
    Views
    1,672

    Disappearing Ranges

    The attached workbook has 2 ranges defined with scope Sheet3.

    The range bbb refers to =Sheet3!$E$4
    whilst the range aaa refers to =Sheet1!$E$4

    There is a macro in there which attempts to print...
  11. Replies
    13
    Views
    2,805

    I'll try that.I already use...

    I'll try that.I already use another_range_object.value = range_object.value which does the equivalent of Paste Special Values on a whole range. It's just a pity that there is no such shorthsnd for...
  12. Replies
    13
    Views
    2,805

    Well, one can do a copy via an object (i.e. not...

    Well, one can do a copy via an object (i.e. not via the clipboard) using:

    range_object.Copy Destination:=another_range_object

    As well as copying the data, I also wish to copy the column...
  13. Replies
    13
    Views
    2,805

    Copy Excel column widths via object

    I suspect the answer is no, but is there a way to copy/paste column widths without going via the clipboard?
  14. Replies
    1
    Views
    685

    Pivot vs Filter - strange results

    The attached workbook has a single column table on Sheet1 and a Pivot Table based on it on Sheet4.

    If you look at the Pivot Table it has 2 rows for AL but click on the Filter arrow for the single...
  15. Replies
    6
    Views
    563

    Re: Unique within group (2002 SP3)

    Wow Hans. Not only does it work, it is better than my original formula (which did appear to work OK when there was only one form present).

    Thank you, Thank you, Thank you, Thank you.
  16. Replies
    6
    Views
    563

    Re: Unique within group (2002 SP3)

    In all of the subrate ones. It is showing FALSE on all of them :-(
  17. Replies
    6
    Views
    563

    Re: Unique within group (2002 SP3)

    Doesn't seem to in this extended version.
  18. Replies
    6
    Views
    563

    Unique within group (2002 SP3)

    In the attached sheet, as part of a selection formula, I use AND(OR(LEFT(H4,2)="Ra",LEFT(H4,2)="Ch"),COUNTIF(OFFSET(F4,0,0,-ROW()+1,1),F4)=1 to identify the first occurrence of a Radio Button or...
  19. Thread: Pesto

    by Paul Lautman
    Replies
    5
    Views
    828

    Re: Pesto

    I use it as a base topping for pizza
  20. Re: Calling all cells (well addressing really) (2002 SP3)

    But did you see Rory's one, no selecting, no looping!
  21. Re: Calling all cells (well addressing really) (2002 SP3)

    You were just soooo close!

    it needs to be this:
    <pre>With Selection.Tables(1)
    .AutoFitBehavior wdAutoFitContent
    .AllowAutoFit = True
    End With
    </pre>

    otherwise all it does is work on...
  22. Re: Calling all cells (well addressing really) (2002 SP3)

    Well sorta. My post did actually say "short of selecting the whole table" as normally in VBA you can achieve most things without selecting.

    This is quite similar to what I had, except I also had a...
  23. Calling all cells (well addressing really) (2002 SP3)

    I'm never sure whether to ask Word VBA questions in the Word or the VBA forum. This one one the coin toss today!

    When I want to set a word table so that the width automagically adjusts to the...
  24. Replies
    7
    Views
    571

    Re: Missing property? (XP 2002 SP2)

    I've never really played around with table styles. I'll take a look, thanks.

    However, very slow is relative. The macro does 10 tables in about a second which is quick enough for me.
  25. Replies
    7
    Views
    571

    Re: Missing property? (XP 2002 SP2)

    Yeah I got that,
    but this is the same table. All the other properties seemed to get passed OK, but that one did not.
Results 1 to 25 of 203
Page 1 of 9 1 2 3 4