Converted my dataset to a table .

[Sunline]

Hello all ,
Ive just had a macro VBA work written for me by a very trustworthy source .

My excel worksheet was quote "converted your dataset to a table in order to get the most efficiency out of the calculations".

Im extremely happy with my new macros but i have no idea how to change my sheet .
Could some one give me some basic steps where to find these tabs im guessing up top of my worksheet .
Many thanks .

 

[AhoyNC]

Put your cursor in a cell of your database. Then go to INSERT on the ribbon and then TABLE.

See attached link:
[TABLE="width: 426"]
<colgroup><col width="426"></colgroup><tbody>[TR]
[TD="width: 426"]http://www.contextures.com/xlExcelTable01.html[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

Are you asking how to convert your data range to a table, or the conversion is already done and you want to find where it is?
Why ask the trusted source?

 

[Sunline]

Thanks AhoyNC , think i got this to work but my macro isnt .

I would ask but i thinks its going on friday night in USA so will ask next week .
Thanks for all advice .