Results 1 to 44 of 44

IF condition copy paste Range(ActiveCell.Offset(,) in new sheet

Threaded View

  1. 07-05-2017, 10:59 PM #22
    incobart
    incobart is offline
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    247

    Re: IF condition copy paste Range(ActiveCell.Offset(,) in new sheet

    Can do like this ?
    condition 1 OR condition 2
    condition 2 = If( tCell.Value < -0.1 AND A-cell <-0.01) Or (tCell.Value > 0.1 AND A-cell >0.01)

    or too complex ?
    Last edited by incobart; 07-06-2017 at 12:26 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help! - Copy Range (Sheet1,A10:F50), Paste Range (Sheet 2,A1:F41), Offset Range & Repeat
    By cjtimmer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 06:27 PM
  2. [SOLVED] Range offset copy and paste
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2014, 02:17 PM
  3. Range for activecell.offset
    By Folshot in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2011, 04:34 AM
  4. Dynamic offset range copy/paste
    By elxan0611 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2010, 04:45 AM
  5. activecell.copy and offset
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2010, 10:07 PM
  6. Copy range, offset, then paste
    By WillysK5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2009, 10:55 AM
  7. Range Select with ActiveCell and Offset property
    By AJ Master in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2006, 06:26 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1