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!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JohnEOasis

    Excel Freeze Panes For Menu

    Thank you.
  2. JohnEOasis

    Excel Freeze Panes For Menu

    Thank you for your reply. I added a user form and got it to load when the workbook opens; however this keeps the user from accessing the sheet while the menu is open. Is there a way around this with out haveing to close and reopen the menu everytime?
  3. JohnEOasis

    Excel Freeze Panes For Menu

    I have googled and searched Tek-Tips and can not find the answer so I thought I would post my question. I created a menu in Excel with shapes and I need the menu not to move either vertically or horizontally when the user sctolls. To complicate things I have a header row that is frozoen as well...
  4. JohnEOasis

    Get the Source Data of the ActiveChart

    Thank you for your replies, The user used buttons/sliders/combo boxes to select the data for the chart. That is how they move around the chart. I have found a solution. I set a universal range variable to a default then update it when something changes that default.
  5. JohnEOasis

    Get the Source Data of the ActiveChart

    The Chart can change either by a single row or many rows and columns at once. It depends on how the user moves around the chart.
  6. JohnEOasis

    Get the Source Data of the ActiveChart

    I created a dynamic chart and need to know the range of that chart when a button is clicked so I can reset the chart to that same range later on.
  7. JohnEOasis

    Get the Source Data of the ActiveChart

    Does anyone know how to get the range of the Source Data of a chart in Excel using VBA?
  8. JohnEOasis

    Excel 2007 found unreadable content...

    While I understand this is a common issue and have searched for a while before my initial post; not only here but across the net; I have not found anything that is related to my specific issue. I can open it without issues outside Citrix but get this error when I try and open it in Citrix.
  9. JohnEOasis

    Excel 2007 found unreadable content...

    I have an Excel 2007 document that opens fine when I open it with a local copy of my Excel. When I try and open the same document from the same location with Citrix I get the Excel found unreadable content in myexcel.xlsm... I click yes and get no more errors; but I do not like this message. Has...
  10. JohnEOasis

    Enter Key and Hidden Columns in Excel 2007

    Thank you both this solved my issue.
  11. JohnEOasis

    Enter Key and Hidden Columns in Excel 2007

    I have a worksheet with a group of hidden rows and the are locked. If the user hits the down arrow it skips past these ok but if they hit the enter key the curser moves to these hidden rows. Is there a way to make the enter key act like the down arrow?
  12. JohnEOasis

    Object variable or With block variable not set

    I cannot believe I missed this... It was on the worksheet change event; the code changes the event = endless loop! Thank you for all your help this was just a boneheaded mistake and I did not even think it all the way through.
  13. JohnEOasis

    Object variable or With block variable not set

    Thank you for your post. I tried it and I still am getting the same error.
  14. JohnEOasis

    Object variable or With block variable not set

    it fails on the first output line OutputRange.Item(1, 1).Value = InputRange.Item(1, 2).Value
  15. JohnEOasis

    Object variable or With block variable not set

    When I run the following code I get an Object variable or With block variable not set error and can not figure out why any helpl would be appriciated. Dim InputRange As Range Dim OutputRange As Range Set InputRange = Sheets("Misc").Range("A18:E18") Set OutputRange =...
  16. JohnEOasis

    Find a cell in a range

    Hi All, I need to see if a cell is referanced in a range... ie Cell G32 could be in A1:L50 or G1:G60 of Sheet2 B20:H40. Is there an easy to find these referances vs the trace dependents?
  17. JohnEOasis

    Hide a Column In A ListView

    Thank you myListView.ColumnHeaders(0).Width = 0 worked.
  18. JohnEOasis

    Hide a Column In A ListView

    I have a ListView that is built dynamically and need to hide the last column. Is there a way to do this? I am using Excel 2007.
  19. JohnEOasis

    Regular Expression

    I have a field that I need to sort on. That field that could be a number or text. It currently sorts numbers as 1 10 2 3 30 31 32 4 5 6 7... I need them to sort 1 2 3 4 5 6 7 8 9 10 11 etc... Is there a way to do this with a regular expression? Such as adding x number of spaces to the number...
  20. JohnEOasis

    Record Specific Rows

    Code correction: While Not myRecordSet.EOF nameRange.offSet(nextR, 0) = myRecordSet(0).Value myRecordSet.Move (1) nextR = nextR + 1 Wend

Part and Inventory Search

Back
Top