Calculating the column

  • Thread starter Thread starter NO
  • Start date Start date
N

NO

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
 
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.
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a value from one column using an array and a single row 1
Calculating times in excel 1
Calculation Time 2
sumproduct to calculate total based on non-continuous columns? 1
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Calculate Help 2
Two Totals from the same column 2
Counting years 2

Back
Top