I get object related errors on the line with debug: "Run-time error '424'" or 1001. I know there is nothing wrong with the code. Comp was restarted, excel process shutted down... Have no idea what's going on. PLEASE HELP
Please Login or Register to view this content.
What are you trying to do?
i is an undefined variable and swsr is a single value, not an array. Therefore you cannot reference an element of the matrix swsr as you are trying?
Really? it would work if you defined i.I know there is nothing wrong with the code.
Hi, Stephen,
I agree on i but I doubt that a single cell would have more than 1 and 1 as limits for the bounds of the range.
@Alexxander:Please Login or Register to view this content.
Your thread title needs an update - itīs not fitting with what you ask.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger - see what happens when you do this:Please Login or Register to view this content.
The ability to index outside the extents of a range is very convenient -- I use it all the time. And indices can be zero or negative, as long as the resulting reference is valid:
Please Login or Register to view this content.
Last edited by shg; 11-18-2013 at 10:47 AM.
Entia non sunt multiplicanda sine necessitate
Hi, Stephen,
thanks for the clarification.
Ciao,
Holger
Well, i found the the mistake in my original code .
I first set swsr to be Range("A1"), then deleted the entire column "A" and the tried to refer to swsr. Dump.
shg: I was thinking that 0 was invalid, as in row 0, but of course you made me realise this isn't a problem. If you don't declare i, what type does Excel assume and would that cause an error though?
If you run the code in post 1, the value of i is "empty" and it creates an error. The type is variant/empty on an undeclared and unused variable.
Had it been declared as a Long, it would have worked, but for the fact that it's in the first row.
Actually the error is because 0 implies the row above and we are starting at row 1. This does not error if you turn off option explicit:Please Login or Register to view this content.
I don't like this code haha.
Again, it's very convenient. If r is the data range of a table (small t), r.Rows(0) is the header.
Of course, I guess it is confusing, because I would normally use .offset to achieve that and so a different base for the reference.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks