View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default calling variable within string

Cells(i,j).Value = "a"

BTW if i is row and =5, and j is column and 13, then you are talking M5 not
E13.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
ups.com...
thanks a lot... also another question..

if i know that a cell row is i and cell column is j (i and j are
variables), how do i get it in the regular cell address
(Alphabet-number) format..like i=5, j= 13, how do i get E 13
and assign it as

a = "e13"

thanks again!