Sample of Visual Basic macros for working with arrays in Excel

[Silent~Kid]

Hello friends,
I have done some basic coding in Visual Basic Application in Excel. I am working with the macros that are used in an arrays. I have tried a lot of coding for that but I am getting an error everytime. I think that I am going wrong somewhere, so thought to ask you guys for the help. Can someone over there can provide me the sample of Visual Basic macros for working with arrays in Excel.?? Any other information related to the topic would be grateful.!!

[Macarenas]

I think that you should first know about the macros properly to understand the coding of it in VB. A macro can automate repetitive tasks. Two different methods are used for creating Excel macros :

• Record a user sequence
• Programming in VBA

In absolute mode, the cursor moves to a cell reference well defined. By cons, in relative registration is on the move. In relative performance can move the cursor over cells lacking.

[kattman]

Visual Basic for Applications (VBA) is a programming environment that supports and automates most desktop applications from Microsoft. Excel often refuses to execute the VBA program (it also called macros or macros). When opening a workbook containing the code. For filling an array and copying it into a spreadsheet, follow the steps :

1. Open a new workbook.
2. Press Alt + F11 to run the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Then you will have to type an appropriate code in module sheet.
5. On the File menu, click Close and Return to Microsoft Excel.
6. Select Sheet1.
7. On the Tools menu, select Macro and then click Macros.
8. In the Macro dialog box, click Sheet_Fill_Array, and then click Run.

[chroma]

If you want to retrieve values from the spreadsheet and fill the array, follow the steps mentioned below :

1. Open a new workbook and enter values in cells A1: A10 on Sheet1.
2. Press Alt + F11 to run the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Then type the code in the module sheet.
5. On the File menu, click Close and Return to Microsoft Excel.
6. Select Sheet1.
7. On the Tools menu, select Macro and then click Macros.
8. In the Macro dialog box, click From_sheet_make_array, and then click Run.

[NIcaBoy]

I am providing the code that you have to insert into the example provided by the 'chroma',

Sub From_sheet_make_array ()
       Dim myarray As Variant
       myarray = Range ( "a1: a10"). Value

       'Looping structure to look at array.
       For i = 1 To UBound (myarray)
      	 MsgBox myarray (i, 1)
       Next
    End Sub

[Soumen]

For passing and receiving an array in excel, follow the steps given below :

1. Open a new workbook.
2. Press Alt + F11 to run the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Type the following code in the module sheet :
   

   Sub Pass_array ()
          Dim myarray As Variant
          myarray = Range ( "a1: a10"). Value
          receive_array myarray
       End Sub
   
       Sub receive_array (thisarray)
          For i = 1 To UBound (myarray)
         	 MsgBox myarray (i, 1)
          Next
       End Sub

5. On the File menu, click Close and Return to Microsoft Excel.
6. Select Sheet1 and highlight the range A1: A10.
7. On the Tools menu, select Macro and then click Macros.
8. In the Macro dialog box, click Pass_array, and then click Run.