Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read EXCEL table
Hello! I've a problem.
I have an excel sheet thath contains a table made of 16 columns and not specified number of rows ( for example 10-100-1000 etc.). My problem is: I want to read this table, using VBA. Now I read each cell, and when I read an empty value, I assume that there aren't any values to read. My question is: Can I read this table in one time ( I've defined the RANGE object that contains column A:R)? Thank you for response. By. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read EXCEL table
Dim vArr as Variant
Dim rng as Range set rng = Range("A1").CurrentRegion set rng = rng.resize(,16) msgbox rng.address vArr = rng.Value for i = 1 to ubound(vArr) for j = 1 to 16 'use varr(i,j) Next Next -- Regards, Tom Ogilvy "Roberto Cortiana" wrote in message ... Hello! I've a problem. I have an excel sheet thath contains a table made of 16 columns and not specified number of rows ( for example 10-100-1000 etc.). My problem is: I want to read this table, using VBA. Now I read each cell, and when I read an empty value, I assume that there aren't any values to read. My question is: Can I read this table in one time ( I've defined the RANGE object that contains column A:R)? Thank you for response. By. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read EXCEL table
Thank-you very much!!!!!!!!!!!!!!
IT WORKS CORRECTLY. "Tom Ogilvy" ha scritto nel messaggio ... Dim vArr as Variant Dim rng as Range set rng = Range("A1").CurrentRegion set rng = rng.resize(,16) msgbox rng.address vArr = rng.Value for i = 1 to ubound(vArr) for j = 1 to 16 'use varr(i,j) Next Next -- Regards, Tom Ogilvy "Roberto Cortiana" wrote in message ... Hello! I've a problem. I have an excel sheet thath contains a table made of 16 columns and not specified number of rows ( for example 10-100-1000 etc.). My problem is: I want to read this table, using VBA. Now I read each cell, and when I read an empty value, I assume that there aren't any values to read. My question is: Can I read this table in one time ( I've defined the RANGE object that contains column A:R)? Thank you for response. By. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connection of Excel 07 pivot table to Access Query makes DB read o | Excel Discussion (Misc queries) | |||
Excel-read a table | Excel Worksheet Functions | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
How to read from a SQL Server table into Excel and use the Excel cell format as in the database | Excel Programming | |||
How to read a SQL Table into Excel change the data and write back into SQL | Excel Programming |