Search results for query: *

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

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

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

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?

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

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?

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.

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

I am retrieving information from an SQL database and storing in a recordset. I want to get a specific column in the record set and insert in into an specific column in Excel. I can loop through the record set and see all the columns however I am not sure how to get to a specific column in the...

I have a function that I need to pass 3 fields in a query to. The function accepts EventID StartDate and EndDate and returns each day of the week. I need to get ALL of the EventIDs and Start and End dates from the events table. I an not figure out how to loop through the table to pass each of...

I have a start date i.e. 8/3/2008 and an end date 8/9/2009 and I need to return all the days of the week and date between these dates. ie Sunday 8/3/2009, Monday 8/4/2009, Tuesday 8/5/2009 etc…. I am a real newbie with SQL and have no clue where to start; any help would be greatly appreciated.