I am still stuck. I ahve provided the entrie code below. My last issues is that I want to change the refence to "Output1" and "Output2" after each pass through the calculator, so that the anser are written to O2:P2, the O3:P3, then O4:P4, and so on.
Thansk to your help, I am close, but not...
I have worked out the code to write the values as described above, but now I am stuck with the answers.
I need to write a value to a range ("Output1"), then change the location of "Output1" by one row (down). Thus my code can write the new value to "Output1", one row lower.
I tried...
Quick Question - how do I run the code to change the value in a named range on multiple named ranges. I tried the code below ( and other variations) with no luck).
Sub
Dim v1 As Range
Dim v2 As Range
For Each v1 In Range("B3:B14")
[Input1] = v1.Value
For Each...
I have code which sets the value of range "Input1" to the vlaue in "B2".
I would like to add code which will change the value of range "Input1" to the contents of "B3", call/run another macro, then change the value of range "Input1" to the contents of "B4" run the macro, and so on until there...
I am looking for a piece of code that will change the value in a range in Excel VBA. For example I have a range named "Input1" which contains the vlaue in cell "B2".
I am looking for code which will change the value of "Input1" to the vlaue in the cell "B3", then "B4", "B5", etc.
Any thoughts...
When I open a pop-up dialog box in IE 6.0, sometimes the content is not all available (the screen is not full-sized, nor are there scroll bars to navigate).
Any thoughts as to why this occurs? Any settings in IE or XP which are preventing me from seeing the entire box?
Thank you ina advance...
Thought this one was dead! Glad to help...
Based on the path I followed, it would depend on the type of action query you use. An update query makes global changes to a group of records in one or more tables. It will point to the tables you assign in the design mode. An append query adds a...
Thanks for looking for me, I had already done the same. I have an old license of Office 2000, but I also found Office XP Developer on some discount software web sites for about $450. So this looks like the way to go.
As a heads up, the MS sales person told me SQL Server Developer has the MSDE...
Thanks. Since I already have Office XP, it seems wrong to have to buy Excel, Word, Access in another package just to get the Developer Tools. $800 to buy software I already have - ouch.
Maybe if I was smarter.....
I have an Access db that I need to run on workstations that do not have Access installed. I am told that I can package and deploy the db, but I need software to do so. I have Access 2002.
I called MS and was told that I could use Visual Basic.net. I called back to ask a few questions, and was...
This worked. I looked but could not find a source to explain the syntax for this field in the update qery in Access.
Your direction did the trick. Thanks
Thanks for the reply. I tried the update query, but it wrote data over top of the data in the fields in the master file.
I used the syntax: [tablename]![fieldname]
Is there other syntax I shoudl use. I have the update query written, it just didn't work the way I need it to.
I have two tables that users have been entering data into. Both tables have the same records, but the fields come from differnt sources, so users are entering data into fields in each table.
I need to join (merge? append?) the two tables so that I have all the data in one table.
I would like...
I have a MS Access table containing loan data. We are collecting pieces of data from various sources, all of which end-up in Excel spreadsheets.
I would like to be able to populate fields in the table, based on the data in the spreadhseets.
For example, in the db, each record now has a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.