Results 1 to 3 of 3

Find/Replace VBA for a specific column

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2011
    Location
    Watertown, CT
    MS-Off Ver
    Excel 2003
    Posts
    12

    Find/Replace VBA for a specific column

    I want to run several find and replace commands. I'm not sure how to limit the scope of the command to a specific column.

    I tried this macro to replace all spaces in column A with the letter N but the command runs without making any changes.
    Sub reppp()
    Columns("A").Replace What:=" ", Replacement:="N", SearchOrder:=xlByColumns
    End Sub
    Thanks so much!
    Last edited by boolean; 03-16-2011 at 12:58 AM. Reason: Added Code Tags

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