Replacing cell values

Solved/Closed

abhi - May 26, 2012 at 02:10 PM
abhi - May 27, 2012 at 07:05 AM

Hi,

My requirement is to replace the cell values only for a given range. And my range is only the cell values in a given single column.
Below is the code I am using.

Sheets("Sheet1").Select
Range("A3", Range("A3").End(xlDown)).Select
Cells.Replace What:="smalldatetime", Replacement:="date", LookAt:=xlPart, _

But the issue I am facing is that the cell values are getting replaced in the columns B and C as well for the matching word, though columns B and C are not in the range specified.

Can anyone please guide me where I am going wrong.

Thanks in advance for help.

Replacing cell values
Replacing batteries in firestick remote - Guide
If a cell has text then return value ✓ - Excel Forum
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
An example of a cell is a blank cell ✓ - Programming Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 26, 2012 at 05:38 PM

This part is what you are doing wrong
"Cells."
you need "selection."

abhi
May 27, 2012 at 07:05 AM

Thanks a lot for inputs. It's working now the way I want :)

Similar discussions

help me to add particular cells

Excel function question

Fill adjacent cell with number from text answer

Return Seq Values Until Blank value then return different set of seq values

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!