View Single Post
  #3  
Old November 17th, 2009, 09:30 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 1,896
Default Make Excel see columns as rows and rows as columns

How are you addressing the cells? In a formula, in VBA code? If a formula,
give us an example.

"Xane" wrote:

Okay, I have a bit of a difficult problem. I'm using excel to make a map for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that for
example 13,100 doesn't get you to row 13 and column 100, but to column 13 and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!