understanding issues with INTERSECT function in VBA
Good morning.
In an application I'm currently developing, I read two two pieces of data from a list (x,y), then map each x,y pair into a table which has X columns and Y rows. Everything works fine except I've found that if I don't select the row and column prior to using the intersect function the routine fails with the following error: Run-time error 13: Type mismatch My psudo code looks like: find the column in the table corresponding to the X value in the list select column X in the table (application.Intersect (rangeX, rangeY) where |
All times are GMT +1. The time now is 12:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com