J
Joe Kickass
I'm writing that app in VB.net that goes into an excel file row by row and
extracts the information and stuffs it into an array for comparison later.
Problem is, I'm having trouble testing for merged cells (I can only catch
them in an error at the moment), and I can't seem to extract data from merged
cells.
Let me give some context to this. Lets say I have a group of data I want to
extract from a worksheet 7 cols wide and X rows long. Every X (random) number
of rows, there's a row of merged cells (e.g. f1:f7) as a header to seperate
groups of data.
How do I deal with these rows of merged cells when creating a range?
TIA!
extracts the information and stuffs it into an array for comparison later.
Problem is, I'm having trouble testing for merged cells (I can only catch
them in an error at the moment), and I can't seem to extract data from merged
cells.
Let me give some context to this. Lets say I have a group of data I want to
extract from a worksheet 7 cols wide and X rows long. Every X (random) number
of rows, there's a row of merged cells (e.g. f1:f7) as a header to seperate
groups of data.
How do I deal with these rows of merged cells when creating a range?
TIA!