Results 1 to 10 of 75

Thread: vba Copy Paste Conditional to put remark 1 2 3 .. etc

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-21-2020, 03:39 PM #11
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    my mistake....it should be ...
    Code:
    Ws3.Range("B" & cnt & ":" & CL(Lc) & cnt & "").ClearContents
    Cnt is row number , like 2 or 3
    Lc is last column number , like 2 or 3 or 4 or 5 .... and so on
    CL(Lc) is last column Letter like B or C or D or E ..... and so on


    So
    __ "B" & cnt & ":" & CL(Lc) & cnt & "" __
    is like
    __ “B2:D2”
    or
    __ “B2:F2”
    or
    __ “B3:G3”
    .. and so on
    Last edited by DocAElstein; 03-21-2020 at 04:08 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Dir File Copy and Paste: Check if file exists then copy file from one directory to another. Bat File
    By fixer in forum Test Area
    Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. VBA -- Copy/Paste across sheets
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 09-21-2012, 02:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules