Search results for query: *

I am trying to create a variable that will give me a runningsum of another variable. For some reason I keep getting an #ierr error when I put the formula in. However if I change the Runningsum to a runningcount my numbers return correctly. I have a feeling I am doing something wrong. Does...

I found the following code from using the Macro REcorder to print row 5 on every page, however it doesn't work. activesheet.pagesetup.PrintTitleRows = "$5:$5" Can anybody tell me why this would not work? thanks!

Anybody have any code to set a width of a column to a certain value? I tried the following and it didn't work: ActiveSheet.Columns("A:A").EntireColumn.Width = 19 thanks!

I need to convert a range of cells from number stat format to a currency format. Can anybody help me with some code to do this? thanks!

What is some code I can use to move a worksheet to the end? I tried using the following, but it didn't work Worksheets.Move after:=Worksheets(Worksheets.Count) Any help? thanks!

I am trying to do a workbook_open command. I want checkboxes to be selected when the workbook opens. Here is the code I have CheckBox13.Value = True But everytime I open the workbook, I get an object required error and my line listed above is highlighted. Any suggestions? I think I am...

Thismay be a stupid question, but I have completely run out of options. I want when I enter in 00002 into a cell to show up as it appears. Right now it is converting it to 2. When I try to format the cell as text it still give me a 2. Its only if I enter is as '00002 will it return exactly...

I am trying to create a subtract query but it is not working. What I want is a list of IDs that are not in query 2 or query 3. In BO terms this is what I am trying to do: Query 1: Family; ID; Sales Subtract 2: Family; ID; Orders - Where Program in list (23,35,54) Subtract 3: Family; ID...

I have a spreadsheet that I have opened using the following code: ximpMY = txtimpmy.Value WorkbookImpromp = "c:/Deferred Revenue_" & ximpMY & ".xls" Workbooks.Open Filename:=WorkbookImpromp I would now like to activate it. I have tried using the following code...

I am trying to color a range. I cannot figure out the code to define my range. I want it to be Row = rnum column A to W (or 1 to 23) I know the syntax is activeworksheet.range("RANGE")..Interior.Color = RGB(211, 211, 211) But I don't know how to put my range in the "RANGE" variable...

I am getting an overflow error everytime I try to use a variable. This is the code I have: Dim xunits As Long Dim xrevenue As Long Dim xholdback As Long Dim lcleaninvoice As Long Dim lfinholdback As Long ActiveSheet.Cells(gdpcarline, 8).Value = xunits ActiveSheet.Cells(gdpcarline, 9).Value...

I have some code that I am trying to get to run. Logically this is what I want it to do: For gdprnum = 1 To 150 gdpcarline = ActiveSheet.Cells(gdprnum, 1).Value if volumcarline = gdpcarline Then Workbooks("NEW 04_FCST-May.xls").Activate Worksheets("Volume Summary by...

I have a complex if statement I need to make and I am not sure how to do it. This is the data I have: AN3345 AN1348 DP3457. I need to insert a line when it changes from AN to something else. I was doing a loop to check if carlineold = carlineold, but thats not going to work because as...

This is probably a really stupid question but for some reason I cannot get my variable to populate correctly. I need to get the value of a cell into a variable. This is what I am using: carline = Cells(rnum, 1).Value But everytime it keeps coming up empty. rnum is = 2 so it should be...

I want to give someone access to Supervisor, but only for a certain user group. I want them to be able to update and maintain that user group. Is that possible to do? thanks, Kelly

I have an issue where I have a calculation that needs to use a variable that has a previous function in the definition. This is what it looks like: Month 01 | 02 | 03 Variable A 5000 | 2336 | 1434 Variable B 500 | 500 | 500 Variable C #ERR | #ERR | #ERR...

I was getting a #Computation Error while trying to create a variable with a if statment in it. I know the reason for the error (One of the varialbes in the if statement is missing from the data set results). I know that one of the solutions is to put the missing object into the report and hide...

Does anybody know how to hide data? I have a report that looks like this Month 01 02 03 Variable A 2 4 Variable B 2 4 6 Variable A is a previous function of Variable B. I am looking to have only columns 02 and 03 show up, but because of the previous...

Does anybody have any code that I can use to put the results of a query in a variable in MS Access? I have an SQL statement that gives me a field. I want to get that field into a variable, but I am really struggling. Any help would be great. thanks

I would like to setup a report to run in BCA anytime a text file is found. However I can set it up to run either a certain day or time, or it will run once with the file watcher. Can anybody help? Can I get the schedule to be setup to run everytime the file is found, not jsut on a certain day...