Results 1 to 6 of 6

Using Selected cells in specified rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2018
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2013
    Posts
    6

    Post Using Selected cells in specified rows

    Hey,
    I have been trying to figure out, how to replace value in specified row(etc 6 row), if it is selected.

    The macro is pretty simple.

    With Worksheets("Sheet1").Rows(6)
    Selection.Replace What:=Val(1), Replacement:="one"
    Selection.Replace What:=Val(2), Replacement:="two"
    End With

    The code works, but not as intendent. It works aswell in other rows(etc 1,2,3,4,5) not only in row 6.

    Thanks for any help!
    Last edited by kristers77; 10-05-2018 at 02:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select Rows of MULTIPLE Selected Cells?
    By Reminisciences in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2014, 02:49 PM
  2. Code to insert rows between selected cells
    By DeepakS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2013, 08:18 AM
  3. [SOLVED] looking for selected rows or cells
    By meridian2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 10:19 AM
  4. Selecting rows of selected cells
    By jdskin2 in forum Excel General
    Replies: 2
    Last Post: 02-09-2012, 04:34 PM
  5. Copy selected cells/rows to another worksheet
    By Spellbound in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-07-2011, 01:02 PM
  6. Replies: 2
    Last Post: 08-28-2011, 02:39 AM
  7. Replies: 3
    Last Post: 10-06-2006, 03:29 AM

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