Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by khansen97

  1. khansen97

    RunningCount vs Running Sum

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

    Print Row on Every Page

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

    Print Row on Every Page

    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!
  4. khansen97

    Specific Column Width

    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!
  5. khansen97

    Format range to currency

    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!
  6. khansen97

    Move worksheet to End

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

    On Open selecting Checkboxes

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

    Preceding Zeros

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

    Where did BOB go?

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

    Where did BOB go?

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

    Subtract Query

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

    Switching between worksheets

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

    Switching between worksheets

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

    Color a range

    Both ideas worked!! Thank you sooo much!
  15. khansen97

    Color a range

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

Part and Inventory Search

Back
Top