Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
dynamic name ranges
Hi, I am trying to define a range in Excell, dynamically. Currently I am using the following: Insert>Name>Define box - sourcedata =OFFSET(Sheetname!$A$1,0,0,COUNTA(Sheetname!$A:$A),COUNTA(Sheetname!$1:$1)) But my main problem is that each week there is new data, in which the size of the...- Squibbles
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
SQL Statement (DoCmd)
Hi, I am writing a prog. in VBA and i have a vairable (x), and I want to lookup in another table (table_y) to find the relavent group noumber and assign this number to another variable, for later use. Table y has two fields: field 1 - x field 2 - Group No. My SQL knowledge is non-existent...- Squibbles
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Importing TextFiles
Hi, I am trying to import a textfile into Access (using VBA, TransferText). The file has over 400 columns, but I only want to import a selection of columns. Also the first line has column headers and the second line is blank (and so i do not want to import it). How can I do this using VBA...- Squibbles
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
