Results 1 to 15 of 15

Find replace using cells own row number

Threaded View

nigelog Find replace using cells own... 02-23-2018, 06:33 AM
kev_ Re: Find replace using cells... 02-23-2018, 07:05 AM
nigelog Re: Find replace using cells... 02-23-2018, 07:15 AM
kev_ Re: Find replace using cells... 02-23-2018, 07:25 AM
nigelog Re: Find replace using cells... 02-23-2018, 07:28 AM
kev_ Re: Find replace using cells... 02-23-2018, 07:31 AM
mjr veverka Re: Find replace using cells... 02-23-2018, 07:35 AM
nigelog Re: Find replace using cells... 02-23-2018, 07:38 AM
mjr veverka Re: Find replace using cells... 02-23-2018, 07:42 AM
kev_ Re: Find replace using cells... 02-23-2018, 08:02 AM
nigelog Re: Find replace using cells... 02-23-2018, 08:06 AM
kev_ Re: Find replace using cells... 02-23-2018, 08:15 AM
nigelog Re: Find replace using cells... 02-23-2018, 08:31 AM
kev_ Re: Find replace using cells... 02-23-2018, 09:20 AM
nigelog Re: Find replace using cells... 02-23-2018, 09:38 AM
  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Find replace using cells own row number

    As a quick fix in a larger macro I am trying to replace the carried over "=#REF!*F and its its row number" with "D and its row number * F and and its row number"
    I tried this but it gives a static reference to whatever cell is selected at the time

    With Worksheets(2)
        LastRow = .Range("g" & Rows.Count).End(xlUp).Row
        Dim Findtext As String, Replacetext As String
        Findtext = "#REF!"
        Replacetext = "d" & Selection.Row ' does not give me the actual cells row number
        Columns("g8:g" & LastRow).Replace what:=Findtext, replacement:=Replacetext, lookat:=xlPart, MatchCase:=True
        End With
    Any help appreciated
    Last edited by nigelog; 02-23-2018 at 08:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find and replace number over 3
    By KTM450 in forum Excel General
    Replies: 5
    Last Post: 05-21-2015, 07:42 PM
  2. [SOLVED] Replace blank cells with ZERO using Find Replace
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2014, 04:47 PM
  3. [SOLVED] Find and replace on the 1st few number with zero
    By cks1026 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-01-2013, 03:07 AM
  4. Find a number and replace the adjacent cell with other number
    By shafath03 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 09:09 PM
  5. Find any number, but don't replace
    By Johnf42 in forum Excel General
    Replies: 3
    Last Post: 09-14-2009, 08:23 PM
  6. Find, and replace but copy cells before replace
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2007, 08:16 AM
  7. Find Replace Number Starting with 0
    By Amir in forum Excel General
    Replies: 0
    Last Post: 11-10-2005, 01:15 PM

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