Excel-how do I reset the cell to which I go with a Control End?

I work with large files, and frequently want to highlight just the data section. I start at cell A1, hold down the shift key, the control key, and hit the End key. Sometimes this works great; other times, I get lots of empty cells. Is there a way to ...

Message posted on the November 2nd, 2009 - 4:59 PM ET

Change End Point?

My latest Excel creation extends to I342, however if I do Control-End, it goes to I2533. Control-Home takes it to the upper left hand box as expected it should. This is very cumbersome because at opening a Control-End is a quick way to reach the end ...

Message posted on the February 01st, 2010 - 08:34 am ET

Change End Point?

My latest Excel creation extends to I342, however if I do Control-End, it goes to I2533. Control-Home takes it to the upper left hand box as expected it should. This is very cumbersome because at opening a Control-End is a quick way to reach the end ...

Message posted on the February 01st, 2010 - 08:33 am ET

Trying to get info and control a "child" web page

I am working on a project and have gotten to to a point where I need assistance. I have the following code: [code] Sub CommandButton1_Click() 'create a new window Dim web As String Dim AccountCol As Integer Account_Col = 5 Switch_Col = 7 web = ...

Message posted on the July 07th, 2009 - 11:02 am ET

How can I set a "page end" point on a large worksheet?

I am a fairly new user to Excel. I have created a worksheet with over 200 lines of data. When I use the "control end" shortcut, I end up way down at the end, if you know what I mean. Is there a way to set the end of my page at the actual ...

Message posted on the May 11th, 2010 - 10:31 am ET

User Control Font Object

I have been attempting to create a User Control in which I can expose a font object to use for various things in the Control and I've been following the procedure outlined at the following MSDN page: ...

Message posted on the August 17th, 2011 - 03:06 pm ET

Bug#584616: astk: [debconf_rewrite] Debconf templates and debian/control review

This is a multi-part MIME message sent by reportbug. MIME-Version: 1.0 Package: astk Version: N/A Severity: normal Tags: patch Dear Debian maintainer, On Tuesday, May 18, 2010, I notified you of the beginning of a review process concerning ...

Message posted on the June 05th, 2010 - 12:40 am ET

Control of cell comments lsot in Office10

I used to control Cell Comments with the below code Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.DisplayFormulaBar = True If ActiveCell.Column = 2 Then If ActiveCell.Row > 2 Then If Len(ActiveCell.Value) > 0 Then ...

Message posted on the December 18th, 2012 - 05:28 am ET

Bug#654434: Kernel doesn't hibernate, instead you end up on a black screen

Package: linux-2.6 Version: 3.1.5-1 Severity: normal Hi! This happens to me on three different machines, it happens with different kernels and doesn't happen all the times but only sometimes. The typical behaviour is that you get the two first ...

Message posted on the January 03rd, 2012 - 12:40 pm ET

Bug#641174: alsa-base: volume control not working - squeeze - GA-G41MT-ES2L - Intel C2D4500 - Realtek 887

Package: alsa-base Version: 1.0.23+dfsg-2 Severity: important Clicking on volume control shows this message: The volume control did not find any elements and/or devices to control. This means either that you don't have the right GStreamer plugins ...

Message posted on the September 11th, 2011 - 02:20 am ET

Bug#706646: linux: FTBFS after regenerating debian/control (kernel-wedge find-dups errors)

Source: linux Version: 3.8.5-1~experimental.1 Severity: normal To reproduce: vi debian/changelog # and insert a dummy version entry debian/rules debian/control fakeroot debian/rules clean dpkg-buildpackage -uc -us At the end, I get these errors: ...

Message posted on the May 02nd, 2013 - 05:40 pm ET

Display message if form on Tab-Control is Blank

I use the following Function to display a message box on the main form if the selected tab-Sub-form is empty. It works if I'm logged in with access level 1, but if I'm logged in with 2 or > then nothing. I watch the process blow right past the ...

Message posted on the October 23rd, 2009 - 04:29 pm ET

VBE Toolbar Control

I'm working with Excel 2003, and I'm trying to determine if there is a way to get the text in a VBE toolbar control. Specifically, I'm referencing the Standard toolbar in VBE, control ID 3201 (or at least I believe this is the right control). This ...

Message posted on the February 17th, 2009 - 02:55 pm ET

Winsock.SendData yields control to the OS in TCP mode

While debugging, I found out that Form_QueryUnload fires in the middle of SendData method during logoff or shutdown. There is no DoEvents in this code, so SendData must be doing something to process some of the messages. I have a Timer control, and ...

Message posted on the December 27th, 2010 - 05:47 pm ET

		Advanced search
In