Why do I get a subscript out of range error for the following code line in VBA?

**LIL2606** · 02-20-2019, 06:41 AM

Hi all,

Quick question, I created a table on Sheet3 (just in excel not in VB), named it RT and its only headers (Data1, Data2, Data3) and as you create a table and tick my table had headers it immediately adds an empty line.

So I enter VB and write this code line:

Please Login or Register  to view this content.

and I get subscript out of range error on it. WHY??

Please help!

Thanks!

**Olly** · 02-20-2019, 07:06 AM

Because there are no rows of data in your table, and won't be until you put something into the 'empty' line.

**LIL2606** · 02-20-2019, 07:13 AM

Okay.. It is what I was thinking but its confusing because

Please Login or Register  to view this content.

does work..

Anyway. Thank you!

**Olly** · 02-20-2019, 07:38 AM

You may find this useful, to explain the listobject model: https://www.thespreadsheetguru.com/b...t-excel-tables

Why do I get a subscript out of range error for the following code line in VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Why do I get a subscript out of range error for the following code line in VBA?

Re: Why do I get a subscript out of range error for the following code line in VBA? (Simpl

Re: Why do I get a subscript out of range error for the following code line in VBA?

Re: Why do I get a subscript out of range error for the following code line in VBA?

Thread Information

Users Browsing this Thread

Similar Threads

Getting Subscript out of range error in the following code

[SOLVED] VBA 'convert date' code giving 'run time error 9 - subscript out of range'

"Subscript out of range error" in a simple code

Code is giving Runtime Error 9 Subscript out of range

[SOLVED] Can't debug this code. The Arrays are producing a Subscript out of Range error

Subscript out of range error & code not working

Subscript out of range error using all possible combinations code

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions