array values

Hi guys. I am trying to replace a copy/paste special with setting the value of a range to the values of another, but I can't work it out. I receive no error message, but the values not getting written in to my rgto range This is where I am at the moment: The last few lines are the ones not...

Hi all, Firstly, I know nothing about excel formulas, I’m trying to return numeric values by selecting “cash” or “card” in a drop down box with this text that would return a value from multiple rows or cells with the return value, This is a cash book spreadsheet with July to June tabs, any...

Here is the code, in here i am assigning the range("A1:AH1") to array arr1 but when i try to read the array by giving the statement debug.print the first entry in the array is itself coming as empty The code: Private Sub CommandButton5_Click() Dim arr1() As Variant Dim i As Integer Dim j As...

Hi, I have 4 comboboxes in a formcontrol (excel 2007, vba), each combobox has the name: Combobox_01 Combobox_02 Combobox_03 Combobox_04 I want to give all comboboxes the same array values "A","B","C","D","E","F" How do I do this efficiently?, I tried a For-NEXT loop, but I am not sure how to...