ref2

I have some code that is meant to save and close the workbook identified in the select statement (Wes_reference or Riv_reference) but it is not closing it. What have I left out? Sub AddReference() Dim wb1 As Workbook, wb2 As Workbook Dim sh1 As Worksheet, sh2 As Worksheet, site As String Dim...

I am getting an overflow error message and I don't know why. Here is the code: Sub AddReference() Dim wb1 As Workbook, wb2 As Workbook Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet Dim f As Range, client As Variant, Ref As String, ref2 As Integer Set wb1 = ThisWorkbook Set...

I'm looking for a function to populate column 'Hold1'. If a value in Ref2 is present in Ref1, then populate Hold1 with the corresponding value in Hold2 <tbody> Ref1 Hold1 Ref2 Hold2 15 5 35 21 23 2 58 56 16 23 15 9 2 87 25 10 60 1 89 65 13 95 34 65...

Hi let say I have A1:A10 column. Lets say I did filter to that column. My question, which range I should use in my subtotal function. The one before the filter (A1:A10) or after the filter? Also I just noticed that subtotal can take more than 2 arguments! function #, ref1, ref2 etc what ref2 is...

Hi everyone, I'm desperately hoping someone could help me out as I'm really struggling with this issue. I'm trying to create a spreadsheet where my friends can choose something from a drop-down box and depending on their choice, they can only enter text/numbers in a fixed format. So for...