Posted to microsoft.public.excel.programming

Andy

external usenet poster

Posts: 39

Delete first character in ActiveCell

ActiveCell.Value = Right(ActiveCell.Value, Len(ActiveCell.Value) -1)

That did it.

Thanks everyone!

Andy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help with ActiveCell.EntireRow.Delete	Ayo	Excel Discussion (Misc queries)	4	July 20th 08 11:07 AM
Need Help with ActiveCell.EntireRow.Delete	Ayo	Excel Discussion (Misc queries)	8	July 19th 08 04:45 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
Delete rows from activecell	al	Excel Programming	3	September 27th 04 01:07 PM
Delete the row where the activecell is located with VBA	Tim Zych[_2_]	Excel Programming	0	July 19th 03 03:57 AM

All times are GMT +1. The time now is 09:54 AM.

About Us

"It's about Microsoft Excel"