declaring

Can someone please tell me how I should be declaring the following? With Me.ListBox1For i = 0 To .ListCount - 1 If .Selected(i) Then ReDim Preserve arrContacts(cnt) arrContacts(cnt) = .List(i, 0) cnt = cnt + 1 End If Next i End With If cnt > 0 Then Students = Join(arrContacts, "; ") End If...

In VB.NET, a variable is declared using the syntax Dim Foo As Integer = 10 I have just discovered that in VBA this does not work, and must instead be written as either Dim Foo As Integer Foo = 10 or as Foo = 10 Is the second of these an acceptable way of declaring a variable? If not, what...

Hi Guys, Been trying to figure this out using ListObjects.Add, but so far no luck. Here's the scenario... Let's say VBA code dynamically produces an unknown number of column headers on a separate worksheet. I want to declare a table, and format it as such based on how many columns are...

Can I declare a global array that's available to all modules within the workbook, I tried declaring a variant array as Public but it gave me an error

Hi there... just a newbie getting my feet wet with programming in excel. I have a lot of declarations and I'm sure I can be declaring them in a better fashion. Can someone provide a more concise alternative to the following: Dim MyChart As Chart Dim ChartData1 As Range Dim ChartData2 As...

Hello Beautiful People I am trying to use an array that relates a row from a scheduling page I have to a database row in another worksheet. The array "RD_to_ProjSum_Array(RD_Row) takes RD_ROW (my database row) and returns the schedule row excel keeps saying that "Sub or Function is not...

I am getting an object required error for some of my declared variables not sure how to correct it. I probably have more errors than this too if anyone can help me out it would be appreciated I don't have much experience in VBA. Dim i As Integer, j As Integer, k As Integer Dim x As Range, y As...