achavez's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
New Members
Active Posts:
8 (0.01 per day)
Joined:
16-August 12
Profile Views:
145
Last Active:
User is offline Aug 20 2012 08:40 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   achavez has not set their status

Posts I've Made

  1. In Topic: Adding spaces to excel using VBA

    Posted 17 Aug 2012

    Hey DIC!
    I just figured it out!

    i had to write "set" before RNG..so

    set rng = Worksheets("Sheet1").Range("C4:C15")

    This will add 6 additional spaces to the cells.
    Thanks very much!
  2. In Topic: Adding spaces to excel using VBA

    Posted 17 Aug 2012

    Dim rng As Range
    rng = Worksheets("Sheet1").Range("C4:C15")
    Dim val As String
    Dim cell As Range

    For Each cell In rng
    val = cell.Value
    val = val & " "
    cell.Value = val
    Next cell
    End Sub

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

achavez hasn't added any friends yet.

Comments

achavez has no profile comments yet. Why not say hello?