nxt

Hi Everyone, Here i am trying to multiply a particular columns using SUMPRODUCT but its giving me the output as '0' Can i know why is this happening??? With Worksheets("Pivot") finalcolumn = 1 + .Cells(2, 1).End(xlToRight).Column .Cells(2, finalcolumn).Select Nxt = .Cells(2...

Hi Everyone, I need some suggestions how i can solve this Using VBA This is my workbook which i am working in https://app.box.com/s/1rsdix4y6b7k4d9vnu3796g37b065omg In the worksheet("main"),the highlighted column contains the formula which i have mentioned below From above worksheets(in...

I have been trying to copy and paste selected filtered columns from one work book to another but i keep getting the same error about them not being the same size. I can copy and paste them manually but it wont let me do it through my vba code. Can anyone please take a look and let me know if...

Basic Q here, but having trouble finding best answer. This is simple macro I have on a sheet titled "NXT": Sub CPHC_nxt_CB() Range(Range("CB_wipe_area").value).ClearContents Range("CB_formgrab").Copy Range(Range("CB_paste_area").value).PasteSpecial Paste:=xlPasteFormulas...

I been using this macro now for some time and its been working well however I now need to move the entire row dependant on more than one value in colounm B how do I add an additional value Dim i As Long Dim j As Long Dim Lastrow As Long Dim nxt As Long Sheets("Cash").Activate Lastrow...