Results 1 to 17 of 17

error 1004

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    error 1004

    hi, ive got a 1004 problem on below yellow line, whats wrong with this ?


    Sub SplitCells()
    Dim i As Long
    With Application
    .Calculation = xlCalculationManual
    .ScreenUpdating = False
    Sheets("DATA1").Range("B" & Col).Select
    For i = 1 To Selection.Rows.Count
    Dim splitValues As Variant
    splitValues = Split(Selection.Rows(i).Value, ",")
    Selection.Rows(i).Resize(UBound(splitValues) - LBound(splitValues) + 1).Value = Application.Transpose(splitValues)
    Next i
    .Calculation = xlCalculationAutomatic
    .ScreenUpdating = True
    End With
    End Sub
    thanks
    Last edited by hamex; 09-09-2010 at 01:24 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1