Results 1 to 2 of 2

Thread: Create target for particular tools group

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    12
    Rep Power
    0

    Create target for particular tools group

    I have created a group using the code below to create a header: but however with this group , i will need to set a target for each tool group.

    Code:
    Dim LastRowColD As Integer
    
    LastRowColD = Range("A65536").End(xlUp).Row
    Range("Y2:Y" & LastRowColD).Select
    With Selection
    .FormulaR1C1 = "=LEFT(RC4,4)"
    End With
    Sheets("Chart").Activate
    ThisWorkbook.RefreshAll

  2. #2
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Not clearly understandable

Similar Threads

  1. GROUP PIVOT CHART
    By bethrah in forum Excel Help
    Replies: 1
    Last Post: 07-28-2013, 04:44 PM
  2. Target.Value help in Worksheet_Change
    By ProspectiveCounselor in forum Excel Help
    Replies: 3
    Last Post: 07-24-2013, 05:00 AM
  3. Conditional Insert Query Based on Data in Target Table
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-23-2013, 04:24 PM
  4. Event target range
    By bobkap in forum Excel Help
    Replies: 3
    Last Post: 09-13-2012, 05:34 AM
  5. Excel to Excel Data transfer without opening any of the files(source or target)
    By Transformer in forum Excel and VBA Tips and Tricks
    Replies: 14
    Last Post: 08-22-2012, 10:57 AM

Posting Permissions

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