Search results for query: *

Hi, Below is Part of my code. I am hoping someone can explain as to why the seriescollection.values do not work properly.An error does not occur but nothing is put into the source data. The series name code changes correctly.. Any help can be appreciated. Thanks! Current_Month =...

Basically I would like to create a calculated field based on certain pivotfields. I run a weekly report for each fiscal month with a plan and actual column. As weeks progress the source data grows. For example 1/4 Plan, 1/4 Actuals, 1/11 Plan, 11/Actuals, etc so the data source columns grow. The...

Hey all, I am having trouble with a small piece of code right now. Basically I want the last row, go 2 rows up and delete the the whats below. There are three total rows at the end of the worksheet I want to get rid of. The code I have is below: Dim lROW As Integer Range("A5").Select lROW =...

Hello, I am new to VBA (and the learning process is going slow becuase of work hours) but I need help putting together a loop to go through a named range. My code is as follows: Sub test() Dim intlastrow As Integer Dim CN As String Dim lrow As Integer intlastrow = Cells(Rows.Count...

Hello All, Background info: I am in finance with no coding expierence and I am trying to learn VBA (teaching myself). I started to learn/read about VBA about 2 weeks ago so i am very new. I am working toward learning the language as quickly as possible. The question is that I have a piece of...