How to set ActiveCell to a new column?

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

How to set ActiveCell to a new column?

I want to set the activecell to the same row it currently is and set
the column to "B". The activecell can be in any column. I looked
into using "offset", but it would take a bit more (calcing if a
negative or positive offset) than I would suspect. Is there something
like "Set Activecell.Column = "B""?

How do the pros do it?

Carl

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
Set ActiveCell at the first column of the same row...	Dave	Excel Discussion (Misc queries)	2	April 16th 09 08:03 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
activecell.specialcells(xlCellTypeVisible) returns column refe	noel	Excel Programming	1	January 4th 05 04:33 PM
Find ActiveCell.column	LindaMac	Excel Programming	4	November 10th 04 05:48 PM
Activecell.FormulaR1C1 Versus ActiveSheet.cells(column, row)	Ashish Shridharan	Excel Programming	2	February 15th 04 04:46 PM

All times are GMT +1. The time now is 07:42 AM.

Menu

About Us