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!

Register Log in
  • Congratulations Rhinorhino 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&

Status
Not open for further replies.
dondo

dondo

Technical User
Joined
Jan 9, 2001
Messages
2
Location
US
I have been unable to copy or move ActiveCells containing only " ' " or " '123ABC" Data. Help Please.
 
Sort by date Sort by votes
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.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
Copy data between SQL and Oracle
Replies
8
Views
2K
remeng
remeng
foxup
  • Locked
  • Question Question
CDO TLS or SSL
Replies
1
Views
755
foxup
foxup
remeng
  • Locked
  • Question Question
CTRL + BREAK from second macro button
Replies
5
Views
1K
strongm
strongm
kapok1
  • Locked
  • Question Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
773
kapok1
kapok1
remeng
  • Locked
  • Helpful tip Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top