Thread: how to know the column/row of a selected cell in vba?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_4_] Edwin Tam[_4_] is offline
external usenet poster
  
Posts: 23
Default how to know the column/row of a selected cell in vba?
x_col = Selection.cells(1).colum
y_row = Selection.cells(1).ro


----- daryl wrote: ----

How can i determine in VBA the rows OR column (not the address) of
selected cell

if the selected cell is J20, i want to have a separate value assigne
for x_col = 10 and y_row = 2

thank you for the hel


--
Message posted from http://www.ExcelForum.com


Reply With QuoteReply With Quote