Hello, I need to fill an excel column using a calculation

September 25, 2017 at 13:03:59
Specs: Windows 7
I need to fill an excel column using two previous columns and an if condition. I want this to be done in a VBA macro. Any help with the code is appreciated

I am trying this but not working

hisWorkbook.Sheets("Text_File").Range("C2").Select
Selection.AutoFill Destination:=ThisWorkbook.Sheets("Text_File").Range("C2:C1824"), Type:=xlFillDefault
ThisWorkbook.Sheets("Text_File").Activate
ThisWorkbook.Sheets("Text_File").Range("C2:C1824").Select
ActiveWindow.LargeScroll Down:=-43
ActiveWindow.ScrollRow = 21
ActiveWindow.ScrollRow = 19
ActiveWindow.ScrollRow = 17
ActiveWindow.ScrollRow = 15
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollRow = 8
ActiveWindow.ScrollRow = 6
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollRow = 1


thanks


See More: Hello, I need to fill an excel column using a calculation

Reply ↓  Report •

#1
September 25, 2017 at 15:36:59
I do not understand what you are trying to do.

I have no idea what this means:

"I need to fill an excel column using two previous columns and an if condition."

Let's forget about the code that you posted and just have you tell us exactly what you want to do. Keep in mind that we cannot see your workbook from where we are sitting, so you need to be specific with your requirements.

If you want to post example data, please click on the following How-To link and read the instructions on how to post example data in this forum.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question