I am trying to insert rows in an excel table using vba but it only seems to work for one row at a time instead of many. I tried using both a fixed number and a variable but no luck. Some of the commands I've used are:Range(Tbl_Detailed).EntireRow.Insert.ry the code below to add rows to the table only without inserting rows across the entire worksheet. Note that the code expands the table on the worksheet; it does not insert rows across the entire worksheet. However, it inserts rows within the table range and any data below the table moves down. Sub AddRowsToTable().
Related articles: Tonsil Removal. 1  For patients not covered by health insurance, the typical cost of an adenoidectomy with or without a tonsillectomy is $5,000 to $7,000, including the surgeon's fee, hospital charge and anesthesia.
Rating Newest Oldest. Best Answer: It should be around $2,000 to $5000. It all depends on the doctors fee the cost of the facility where you have the procedure done. A tonsillectomy will require anesthesia and depending on the doctor it can take 15 to 30 minutes.Have you seen a ENT specialist a tonsillectomy might not be recommended since you only seem to get it once a year.Source(s): hev81 Â· 8 years ago. tonsillectomy will require anesthesia and depending on the doctor it can take 15 to 30 minutes. Have you seen a ENT specialist a tonsillectomy might not be recommended since you only seem to get it once a year. Source(s): hev81 Â· 8 years ago.