select all rows on a table except last column

[Cele]

Hi,
I want to select all of the area on the table attached called data1. All area minus the last column. How do i go about writting a macro like that?

A4 to J372

Please advise.

Cele

 

[Asheesh]

attachment is missing !!

 

[Cele]

for some reason this site is not allowing me to upload the spreadsheet

 

[Cele]

it works now. here you go

 

[Monty]

Hello Cele

Try this.

Below attatched file is dynamic, tomorrow even if data is increased in rows...it works

 

[Cele]

This is exactly what i needed. A million thanks Monty!!!

 

[jamesexcel1970]

Champ Million thanks by Cele..Wow.
I liked it.

 

[Monty]

Thank u Mr James.