Get the List of Data Name Range: Want the FirmsName Row.Address, UsedRange.Address and BlankRow.Address

[NimishK]

Hello

This is completely different from my subscribed thread 1069919.

The Structure has changed completely. Would like to get
1. the Row.Range Address of the Firm's Name (which shall be in column B but no defined row)
2. the UsedRange. Address just below the Firm uptil the First blank row
3. The BlankRow.Address just below the Firm's USed Range (UsedRange defined from UserFirm's Name uptil row containing'Total')
4. Again Columns are fixed from A to E
5. There are Sub-Headers (rows) just below the row containg Firm's Name
6. One critical assumption what if there is a blank row or Blank rows within the Firms used Range. It has to skip this and display the blank Row just below the Firm's USed Range

ComboBox List to Display the Firms name and clicking on that
TextFirmNameRow.Text = FirmNameRow.Address
TextFirmUSedRange.Text = FirmUSedRange.Address
TextBlankRow.Text = BlankRow.Address

Attached is representation for your Reference
https://www.dropbox.com/s/mgn1avcc65vyume/GettingUsedRangeBlankRowAddress.jpg?dl=0

NimishK

 

[NimishK]

Hello Anyone
Pl refer Post 1 and 6 points and help me
resending the structure. (replica of image sent as per Post 1)
Pl excuse if the foll. structure has not come properly.

A	B	C	D	E
Firm name	ABC				<------|
Date	Shipping Detials	Ref No.	Amount	Amount	|
01-01-2018	Sent	111	4500		|
	(inv 2513)				|
01-01-2018	Sent	112	6000		|
	(inv 2514)				|
03-01-2018	Received	R-1		3000	|
	R-inv(1111)				| Used Range
04-01-2018	Sent		3500		|
	(inv 2515)	113			|
04-01-2018	Received			2500	|
	R-inv(1110)	R-09			|
04-01-2018	Received			7650	|
	R-inv(1110)	R-07			|
07-01-2018	Sent				|
	(inv 2516)				|
	TOTAL		14000	13150	<--------|
					<--------|BankRow
Firm name	XYZ				<--------|
Date	Shipping Detials	Ref No.	Amount	Amount	|
03-01-2018	Received	R-2		5000	|
	R-Inv(1210)				| Used Range
04-01-2018	Received	R-3		4670	|
	R-inv(1111)				|
	TOTAL		0	9670	|
					<-----BlankRow
Firm name	CCC				<--------|
Date	Shipping Detials	Ref No.	Amount	Amount	|
05-01-2018	Sent	115	3500		|
	R-Inv(1215)				| Used Range
					<------|Blank Row To Skip
07-01-2018	Sent	116	2000		|
	R-inv(1119)				|
					<------|Blank Row To Skip
	TOTAL		5500	0	|
					<-----BlankRow

<tbody>
</tbody>

Thanks
NimishK