roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,046
- Office Version
- 365
- Platform
- Windows
- MacOS
I have a macro that I use to simplify data input. The key line is:
ActiveCell.Value = ActiveCell.Offset(-1, 0).Value
The cell it is copying from will be in a certain format. The copy line above only copies the value. How can I drag the formatting attributes with it?
I tried:
ActiveCell.Format = ActiveCell.Offset(-1, 0).Format but that apparently doesn't exist...Excel VBA help only works if you guess close, and that apparently aint it.
Ideas?
Thanks!
ActiveCell.Value = ActiveCell.Offset(-1, 0).Value
The cell it is copying from will be in a certain format. The copy line above only copies the value. How can I drag the formatting attributes with it?
I tried:
ActiveCell.Format = ActiveCell.Offset(-1, 0).Format but that apparently doesn't exist...Excel VBA help only works if you guess close, and that apparently aint it.
Ideas?
Thanks!
