Add space to end of string using VBA

[DougStroud]

I am attempting to add a space to each string w/ this line of code, but get compile error, expected end of statement. Highlights the "=" sign after .Value

For Each c In Range("D4:D" & LRow).Value = "=(c.value & " ")"

Thx,

ds

 

[MorganO]

This should work for you:

For Each c In Range("D4:D" & LRow)
  c.value = c.value & " "
next

Owen

 

[tusharm]

Duplicate: http://www.mrexcel.com/board2/viewtopic.php?t=283797