Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Hi As TopLeftCell is used in both routines I...

    Hi

    As TopLeftCell is used in both routines I guess it was a typo.

    If you want to delete the boxes after getting the values, you could use code like this:


    Sub getValues()

    Set zSht =...
  2. Replies
    50
    Views
    1,438

    Hi RG Great Dilbert explanation! You are...

    Hi RG

    Great Dilbert explanation!
    You are right! Disregard my previous post. I should remember the original purpose of this thread.

    Disabling paste into cells is primarily intended to support...
  3. Replies
    50
    Views
    1,438

    Hi RG I used your file in post#45 and was able...

    Hi RG

    I used your file in post#45 and was able to 'paste' data into a 'reserved area' via Data>Advanced Filter>Copy to another location
    Shall I have a look at how to prevent this?

    zeddy...
  4. Replies
    7
    Views
    267

    Another way would be to visit the site, make your...

    Another way would be to visit the site, make your selections, then use the site's Print Record button.
    This will provide a list in an Explorer window. Use Explorer's File>Save As
    (The default...
  5. Replies
    50
    Views
    1,438

    Hi Martin Post#33 Yes, it wasn't intended to...

    Hi Martin
    Post#33
    Yes, it wasn't intended to prevent pasting from within the same workbook only, as stated, from another workbook. And as I said in post#36

    There are other vba code lines that...
  6. Hi ..puzzled about the message you got in...

    Hi

    ..puzzled about the message you got in post#7.
    I took your sample file, copied a few more test entries, and then ran my routine.
    It worked OK.
    see attached file.

    zeddy
    •Repercussions...
  7. Hi This code will put the values into column...

    Hi

    This code will put the values into column [B] in the corresponding row. Adjust as required.


    Sub getValues()

    Set zSht = ActiveSheet
    With zSht
    For Each Z In .OLEObjects
  8. Replies
    50
    Views
    1,438

    Hi RG ..you are confusing me with •Solid Waste...

    Hi RG

    ..you are confusing me with •Solid Waste Structural Engineer
    ..I was washing dishes at the time.
    ..I've now moved on

    zeddy
    •Head of Potatoes
  9. Replies
    50
    Views
    1,438

    Hi RG ..I need time to compose my detailed...

    Hi RG

    ..I need time to compose my detailed reply.
    I'm in-between switching jobs at the moment.

    zeddy
    •Underwater Ceramic Cleansing Technician
  10. Replies
    50
    Views
    1,438

    Hi Rg/Murgatroyd Re: post#33: I discovered...

    Hi Rg/Murgatroyd

    Re: post#33: I discovered this method in Jan 2001.
    In the file I posted, I protected the VBA to encourage RG to test it first.
    (I thought if RG saw what the code was, he...
  11. Hi Howard ..what about this.. Private Sub...

    Hi Howard

    ..what about this..


    Private Sub Worksheet_Change(ByVal Target As Range)

    zRow=Target.Row
    zCol=Target.Column
  12. Replies
    50
    Views
    1,438

    Hi RG A long time ago I was working on...

    Hi RG

    A long time ago I was working on preventing pasting data into an Excel file.
    See attached file.
    This file has only one routine, which contains only one short line of code.
    (The code is...
  13. Replies
    50
    Views
    1,438

    Hi RG ..OOPs. I missed that. Happy 4th July...

    Hi RG

    ..OOPs. I missed that.
    Happy 4th July for tomorrow.

    zeddy
    Senior Beverage Consultant
  14. Thread: Fiscal Year

    by zeddy
    Replies
    27
    Views
    634

    happy 4th July for tomorrow then Fred

    happy 4th July for tomorrow then Fred
  15. Replies
    50
    Views
    1,438

    Hi RG Great work - getting pretty close. ...

    Hi RG

    Great work - getting pretty close.

    Some additional anomalies:
    On your posted [PasteProtectedSheet], it won't allow you to 'cut'(Ctrl-X) a block of (any) data and then place this anywhere...
  16. Replies
    25
    Views
    1,619

    Hi Brian This is it so far.. ..I tweaked...

    Hi Brian

    This is it so far..
    ..I tweaked Maud's code, and added some Chance cards.
    ..haven't done anything on moving pieces.

    Some time ago I did a post that 'translated Excel sheets and tabs'...
  17. Thread: Fiscal Year

    by zeddy
    Replies
    27
    Views
    634

    My fault. Not not guilty as charged. I...

    My fault.
    Not not guilty as charged.
    I shouldn't have mentioned fractions.
    It was vulgar of me.

    zeddy
  18. Thread: Fiscal Year

    by zeddy
    Replies
    27
    Views
    634

    my t-shirt was 2+2=5 (for large values of 2) ...

    my t-shirt was
    2+2=5
    (for large values of 2)

    zeddy
  19. Replies
    25
    Views
    1,619

    Hi Brian ..please keep this thread open. I'm...

    Hi Brian

    ..please keep this thread open. I'm tweaking some more stuff. Maud's twirling cards are magnificent.

    zeddy
  20. Thread: Fiscal Year

    by zeddy
    Replies
    27
    Views
    634

    I am so positive, I am told that if I were a...

    I am so positive, I am told that if I were a battery I'd be positive at both ends.
    ..now what are we going to do about the 3 out of 2 people who don't understand fractions?
  21. Replies
    11
    Views
    165

    Hi ..does this one work

    Hi

    ..does this one work
  22. Replies
    11
    Views
    165

    Hi Excelnewbie ..count how many entries you...

    Hi Excelnewbie

    ..count how many entries you have in column [A]
    ..I make it four, so the next entry will be on row 5 as per your code line
    newRow =...
  23. Replies
    11
    Views
    165

    Hi Jonathan ..credit to you for spotting that!...

    Hi Jonathan

    ..credit to you for spotting that!
    Welcome to the Lounge!

    ..you deserves your first Thanks!
    ..that makes you 100% thanks in ALL your posts!

    zeddy
  24. Replies
    11
    Views
    165

    Hi ..try this. It was easier to freeze the...

    Hi

    ..try this.
    It was easier to freeze the display, unload the Form, then re-load it.

    zeddy
  25. Replies
    25
    Views
    1,619

    Hi Brian I've been tied up with...

    Hi Brian

    I've been tied up with multi-dimensional tesseracts.
    ..But here is what I've got so far on moving pieces.
    more to follow when I get a chance.

    zeddy
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4