This is an excel sheet i want to find the Cell range index of column name - “Item”, for it i am using
but every time this is giving me range value “E”, i think it is not counting blank cells,
any suggestions that how can i get the original range - “G”,
and this is the case for any column i want to take out the range. @ppr, @Palaniyappan, @ClaytonM
Feel free for clarifications .!!
your requirement is clear but your data is not.
As I can see from your screenshot your actual data range starts from C4 (I assuming that it is your start range when you are reading this excel)
but when you do 65 + column.index then there is assumption that your data range starts from A1 [as char 65 represents alphabate A].
kindly let us know how you are reading your excel file, also let us know if start range is dynamic or not.