looping in vba

Hi everyone I am not very familiar with Visual Basic and need some help. I have a table that calculate costs and depreciations based on pre-selected inputs. The inputs are categorized according to the asset in question, numbered from 1-1.000 (representing 1.000 assets in total): Everytime a...

Hello. I have a worksheet that will contain data in sheet A . Column A. Range can be anywhere from A2:A1000 Trying to figure out how to load 50 rows of data at a time, then send to the software (url) that I am using, etc.. The Process currently works but only up until 50 rows of data as that's a...

Hi- I am new to learning VBA and I need some help! I am looking for a VBA code that will loop through all 50 tabs within an excel workbook and search for any named range that starts with EQUITY and copy and paste all named ranges into one single tab within the workbook. In this case we can name...

Hello All, Can somebody explain to me how to loop through these controls in the macro below??? Thanks Kelly Dim Drng As Range, lrRng As Range With Sheet1 Set Drng = .Range("B7") Set lrRng = .Cells(.Rows.Count, Drng.Column).End(xlUp).Offset(1, 0) lrRng.Value =...