PC Review


Reply
Thread Tools Rate Thread

Calculating the column

 
 
NO
Guest
Posts: n/a
 
      15th Aug 2005
Hi,
Sorry to ask but...
I want to calculate the column for a vert.search function.
Say a want to start the search at column (2*3) [=6], how can I transform the
"6" in "F"?
Thanks very much in advance.

Fred
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      15th Aug 2005
Is this for VBA?

If yes, you don't need to change the number to letters.

activesheet.columns(6)
or
activesheet.columns(2*3)
would work fine.

NO wrote:
>
> Hi,
> Sorry to ask but...
> I want to calculate the column for a vert.search function.
> Say a want to start the search at column (2*3) [=6], how can I transform the
> "6" in "F"?
> Thanks very much in advance.
>
> Fred


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating column A * column B = Results in another column jhun Microsoft Excel Worksheet Functions 2 30th Mar 2010 05:13 AM
Calculating column 'J' and offsetting result in column 'L' on nextblank row (continue to end of sheet) S Himmelrich Microsoft Excel Programming 10 6th Feb 2008 04:23 PM
Calculating Column and off setting calculated value to another column S Himmelrich Microsoft Excel Programming 1 1st Feb 2008 06:26 PM
Sum if is only calculating one column =?Utf-8?B?S29yaUJ1c3RhcmQ=?= Microsoft Excel Worksheet Functions 2 24th Oct 2005 06:02 PM
Calculating totals in a column based on a lookup in another column Michael Wright via OfficeKB.com Microsoft Excel Worksheet Functions 1 15th Apr 2005 09:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:47 PM.