Updating column values on specific Row using VBA

Question

How to update value from xt to xtt in 6th column, first row.

1    2    3   4    5  6

x    xx  xy   xz   x1 xt

y    yx  tt   cc  z3  xcc

Based on above data, I am getting range from worksheet. After getting the Row object, how do I update the Cell value in particular column?

forsvarir · Accepted Answer · 2011-10-11 12:37:44Z

1

As asked, you can update a specific column using the method:

'Sheet.Cells(row, column) = value
' i.e.
ActiveSheet.Cells(1, 6) = "xtt"

If you only want to perform the update if it has a value of "xt", then obviously you'd need to check the contents before performing the update... For example:

If (ActiveSheet.Cells(1, 6) = "xt") Then
    ActiveSheet.Cells(1, 6) = "xtt"
End If

answered Oct 11, 2011 at 12:37

forsvarir

10.9k6 gold badges48 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raj Over a year ago

:I updated my question,After getting row object.I want to update cell value

Collectives™ on Stack Overflow

Updating column values on specific Row using VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related