Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Macro loop, Copy or Move Cell containing " ' " or "'123abc&
- Thread starter dondo
- Start date
cLocKwOrkPRO
Programmer
Uh, how are you attempting to move it?
I'd just set the cell's data to a varaible and then move it.
i.e.
Dim tempVariable As String
tempVariable = SheetCodeName.Range(A6).value
SheetCodeName.Range(A7).value = tempVariable
No matter what is in the cell, it will be moved.
I'd just set the cell's data to a varaible and then move it.
i.e.
Dim tempVariable As String
tempVariable = SheetCodeName.Range(A6).value
SheetCodeName.Range(A7).value = tempVariable
No matter what is in the cell, it will be moved.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Helpful tip
