This is what I am trying to do
1) User manually select a random range in Excel for Office XP (e.g. A8:M10, A20:M20, A30:M:32)
2) User click a VBA Button
2.1 For each row in time
2.1.1) Code should modify the first "column" of the row
2.1.2) Code should set the "Pattern" of the row to grey
2.1.3) On error, stop processing subsequent rows (rows processed could stay as is)
How could I find out the Range "co-ordinates", I think I need the absolute range (because after processing each row, I want to highlight that row Grey (which would lose my selection). How could this be done?
1) User manually select a random range in Excel for Office XP (e.g. A8:M10, A20:M20, A30:M:32)
2) User click a VBA Button
2.1 For each row in time
2.1.1) Code should modify the first "column" of the row
2.1.2) Code should set the "Pattern" of the row to grey
2.1.3) On error, stop processing subsequent rows (rows processed could stay as is)
How could I find out the Range "co-ordinates", I think I need the absolute range (because after processing each row, I want to highlight that row Grey (which would lose my selection). How could this be done?