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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chrisinparra

    Loop through cells in range and copy values to corresponding cell in another range

    Thanks Skip, I found a way to do it. I have defined three ranges: - read_area for the whole read form - edit_area for the whole edit form - edit_area_values for just the green cells in the edit sheet The code then loops through each cell of edit_area, and if it intersects with...
  2. chrisinparra

    Loop through cells in range and copy values to corresponding cell in another range

    I can't upload the workbook as it includes sensitive information. Below is a screen shot of the read_area. This contains formulas in the grey boxes which will have results. On clicking the edit button, the idea is for these values to the copied to the green cells in the second screenshot. The...
  3. chrisinparra

    Loop through cells in range and copy values to corresponding cell in another range

    Yes. Below code produces the below results. On the 11th pass it returns $J$37, but calling for Item(11) returns $I$34. Dim cell_count As Integer For Each cell In Range(read_area) cell_count = cell_count + 1 Debug.Print cell_count & " | " & Range(read_area).Item(cell_count).Address & "...
  4. chrisinparra

    Loop through cells in range and copy values to corresponding cell in another range

    'Read_Sheet'!$I$34 is returned as the 11th cell. This isn't inside the range. It should be 'Read_Sheet'!$J$37 but it's not.
  5. chrisinparra

    Loop through cells in range and copy values to corresponding cell in another range

    Same problem as Item. Range("edit_area")(i) returns the 11th cell from the start, not the 11th cell in the range. Any other thoughts?
  6. chrisinparra

    Loop through cells in range and copy values to corresponding cell in another range

    I have two named ranges which each contain multiple areas. read_area ='Read_Sheet'!$I$24:$I$33,'Read_Sheet'!$J$37,'Read_Sheet'!$C$40,'Read_Sheet'!$E$42 edit_area ='Edit_Sheet'!$V$54:$V$63,'Edit_Sheet'!$U$67,'Edit_Sheet'!$T$70,'Edit_Sheet'!$V$72 I'd like to copy the value from each cell in...
  7. chrisinparra

    Prompting for query criteria even though criteria refers to control

    Thanks to MajP, I played around with msgbox and managed to solve the problem. I am now setting the value of [Forms]![Order Detail]![txtOrderID] in the form open event, and the requery the listbox in the same event. It appears to work. I can only assume that the value of [Forms]![Order...
  8. chrisinparra

    Prompting for query criteria even though criteria refers to control

    I don't know what I am doing wrong here. It is doing my head in but hopefully it is something simple. I have a query as follows SELECT [Count List].Barcode, [Count List].[No Units in Carton], [Count List].[No Cartons], [Count List].[No Singles], [_Item List Current QRY].LastOfDescription...
  9. chrisinparra

    Consectutive dots treated as one character

    I have a formula which returns a preview of a larger string. For example, the full string is "Customer has called twice complaining about his package not arriving." I use a combination of the LEN and LEFT functions to return a preview of this string for the user. This might appear as "Customer...

Part and Inventory Search

Back
Top