How to delete columns (referring to column number)?

**VAer** · 10-18-2024, 09:57 PM

https://www.statology.org/vba-delete-column/

Above code deletes column by referring to column letter.

How should I delete column by referring to column number? For example, how can I delete first 5000 columns?

**protonLeah** · 10-18-2024, 10:18 PM

Range("a:a").Resize(columnsize:=5000).Delete

**VAer** · 10-18-2024, 10:19 PM

Originally Posted by protonLeah

Range("a:a").Resize(columnsize:=5000).Delete

Thank you!!

How to delete columns (referring to column number)?

LinkBack

Thread Tools

Rate This Thread

Display

How to delete columns (referring to column number)?

Re: How to delete columns (referring to column number)?

Re: How to delete columns (referring to column number)?

Thread Information

Users Browsing this Thread

Similar Threads

Populating multiple columns in on sheet by referring to a column in another sheet

Macro to delete certain columns and delete rows based on time in another column

Relative index, or referring to a nearby cell without explicit column/row number?

sum column with restrictictions referring to other columns. How to do this?

Referring to a Column Number in vba code - Found Via Function using Column Letter

Referring to columns by number

VLOOKUP referring to columns to the left of the source column

referring to a column by letter, not number

Bookmarks

Bookmarks

Posting Permissions