ws2

In my VBA code I create arrays from 2 worksheets: ws1 & ws2 I create 2 arrays, one from ws1 & another from ws2 and then loop through both of them (loop2 is nested within loop1) I need a decent standard variable names because I will do this procedure many many times. lws1 & lws2 ? Loop ws1...

Hi all, <colgroup><col><col><col></colgroup><tbody> Costs Costs 2 Total Costs €15,00 €0,00 </tbody> I want to adjust my macro so it adds up the two costs in the totcal costs area. This has to be done fot a lot of rows. In between the rows in this column there are empty spaces. I made this...

I've searched for far too long and can't find the answer so I must post as this has got to be easy for the experts: 2 worksheets, WS1 and WS2. I want to clear contents on the WS2, then ***Link*** WS2 cell C1 to WS1 A3. That is, I want WS2 cell 1 to show "=WS1!$A$3" when viewed from excel and...

Hi, I am new to VBA and struggling to copy data to New workbook. I have wrongly referred the workbook. I want to copy data from ws1 to new workbook. but it is coping to ws2.I have to run macros from ws2 book. as I have placed more macros in ws2. macro is not running when I add new workbook...