-
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.
sheetcounter
-
A
Two dimensions: collection or dynamic array
Hello guys, I need a little help. I have written a piece of code in order to perform massive replacement in the entire workbook. Sub fdfd() Dim SheetCounter As Integer Dim RowCounter As Integer Dim ColumnCounter As Integer For SheetCounter = 1 To ThisWorkbook.Sheets.Count...- Archangelos
- Thread
- cellsrowcounter columncounter.replace integer lookat=xlwhole sheetcounter
- Replies: 2
- Forum: Excel Questions
-
G
Problem when using an array returend by a function
Hi I am getting error (Can't assign to array); also "empty array" error when trying to use an array that contains two values and is returned by a function in the following code : Function ImportSourceFile() Dim NymberOfUpdates As String Dim NumberOfSheets As String Dim...- Grand
- Thread
- dim function numberofdocs sheetcounter string
- Replies: 4
- Forum: Excel Questions
-
K
excel macro why don't it work
Sub datatransfer() Dim j As Integer Dim k As Integer Dim n As Integer Sheets("Master").Activate sheetcounter = 2 k = 24 j = 1 Do Do Until Cells(j, 1).Value = Worksheets(sheetcounter).Cells(15, 5).Value j = j + 1 Loop n = j + 1 Do Worksheets(sheetcounter).Cells(k, 4).Value...- kiril0
- Thread
- cellsn dim help wanted loop sheetcounter
- Replies: 5
- Forum: Excel Questions
