maverick93
New Member
- Joined
- Jan 7, 2010
- Messages
- 23
I am in need of a function to find and give me the row number of the first merged cell in a column.
Right now I have a list A1:C100 and none of those cells are merged accept one row Merge cell. I need a function that will locate this merged cell and return a row number.
so if the the merged cell is in A20:C20 I need the function to return the row number which would be 20.
Thanks
Right now I have a list A1:C100 and none of those cells are merged accept one row Merge cell. I need a function that will locate this merged cell and return a row number.
so if the the merged cell is in A20:C20 I need the function to return the row number which would be 20.
Thanks