View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Convert cells reference to string reference??

Does VBA have a function that will take rows and columns
arguments and return a string reference with letters and numbers??

For example, if I give the function row 1, column 1, then it should
return "A1". (ie. function(1,1) returns "A1")

Is there also an inverse of such a function, if it exists?

thankx