-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
outrow
-
C
Loop through text boxes in a page
Ok, I have working code that looks like this: Private Sub CommandButton39_Click() Dim objWorkbook As Workbook Dim i As Integer Dim arrIn As Variant Dim arrOut() Dim j As Long Dim counter As Long Dim outRow As Long Dim sUser As String Set objWorkbook = Workbooks.Open( _ "C:\Documents\Data.xlsm")...- chroniclesofdave
- Thread
- dim excel outrow userforms vba
- Replies: 7
- Forum: Excel Questions
-
M
VBA Loop refuses to work
hi, I am trying to get this macro to run where there is a number in a cell then it takes the main header and the sub header and transposes it then adds the value but for some reason it refuses to work. the loop variable e.g. datarow for example is set at datarow = 3 but it appears as blank and...- Mari0
- Thread
- datarow dim loop outrow role1col
- Replies: 1
- Forum: Excel Questions
-
K
Using 'With Workbook' and 'Do while' loop through multi workbook
Hi ... I have multiple workbooks saved in a folder and the code below seems to only work for my first file. However, I need it to work for all the files in the folder but can't seem to see where I have gone wrong. Dim wkbDest As Workbook Dim wkbSource As Workbook Dim shtcopy As Worksheet...- KNKN9
- Thread
- dim outrow role1col rolecol strextension
- Replies: 3
- Forum: Excel Questions
