looping formulas

Hi, I have the following code Sub formula() Dim LastRow As Long With ActiveSheet LR = .Cells(.Rows.Count, "A").End(xlUp).Row End With Dim LastCol As Integer With ActiveSheet LC = .Cells(1, .Columns.Count).End(xlToLeft).Column End With...

Hi guys! I wrote this, and got some useful info from here(i guess :) ) now I would like to ask you to give me any optimalization ideas (shortening the code, or runtime) The task for this macro are: let user select files via "Open" window open/close each file copy and paste selected datas below...

Hello all, windows 7sp1 64 bit (8gb ram, i7 dual core proc) with excel 64 bit (64 bit is needed for larger calculations). I need some help with the below formula and how to make it smaller or faster using loops. I am good with powershell, just not excel :) Thank you for your time and help...

So my code is working great, but looking at my code I can't help but think that there must be an easier way to loop through the script so it isn't so repetitive. Any thoughts? Sub Macro1() Dim ActSheet As Worksheet Dim JUNCTION As String Dim BOC As String Dim Amount As String...

have this data on a spreadsheet which I format with a recorded macro but Both the rows and columns change frequently everyday and the macro only works for the cells I recorded . How Do I create a dynamic range and loop the formula to customize the newer and additional rows and columns i.e add...