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...

It won't print what I have specified as the heard row.

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...

To be exact. Here is the error I get: phpBB : Critical Error Could not connect to the database

I keep getting the database is down when I try to go to the site. Is that what you are getting blackrooster?

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...

When I try to put the "Set W1" code in I keep getting an "Expected end of statement error

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...

Both ideas worked!! Thank you sooo much!

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...

xrevenue and xunits are both zero. I put in an if statement to filter out when they are both zero. This solved my problem. I was just trying to figure out if there was another way around this.

I did. And I am still getting the overflow error. This is only happening when my variable returns an undefined result.

I found that it is coming up with an undefined result. Can you help me figure out a way to get around this? Can I put in an if statement? thanks

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...