creating tables using VBA

[hudson andrew]

Hi all ,

I was wondering if someone would help me with tabel creations using VBA .

i have a below code which is working fine but the range selection is little old school . i want code to capture entire data in sheet dynamically rather than hard coding it to one range like below .

Please Login or Register  to view this content.

i really appreciate your assistance in this regards

[davesexcel]

[QUOTE=hudson andrew;4771901]Hi all ,

I was wondering if someone would help me with tabel creations using VBA .

i have a below code which is working fine but the range selection is little old school . i want code to capture entire data in sheet dynamically rather than hard coding it to one range like below .

Please Login or Register  to view this content.

[hudson andrew]

Thanks sir. this is what i was looking for great help you.