Programming

a macro to copy only 2 lines w/i a cell separated by 4 line breaks
Can anyone help me determine how to copy only 2 specific lines from a cell that contains text in 4 lines that is separated using the line break function? ... 14 Apr 2010 20:05

thiscell
in excel/2000, is there some property like 'thiscell' in excel/2007? so, when vba function is called to determine from which cell is called thnx! ... 15 Apr 2010 08:05

Refresh Listbox
Hi All, I have excel userform, which is connected to access database. I have customer details in access dabase. I will search using excel userform, results are displayed in listbox. I will select the listbox item and update the required details. If I click save it saves to database. That is working fine. ... 15 Apr 2010 09:11

Feach data according to cell value
Hello there.. I am trying to get some data from sheet 'April' to Sheet 'Search' using macros.. Its like people can select some criteria's to get the data. 1. if Sheets("Search").Range("E4").value="First" then it should search for Sheets("Search").Range("C4").value in Sheets("April") column 'J' and also ma... 14 Apr 2010 15:34

ScrollRow
What can I add to the code below to set the ScrollRow to 1 and the curser on cell A3? With Worksheets("March") If .Range("C184").Value = "" Then .Rows("184:228").Hidden = True End If If .Range("C184").Value <> "" Then .Rows("184:228").Hidden = False ... 15 Apr 2010 13:39

If specific cell is not empty, copy (or enter) formulas and format
I have a workbook that has several sheets that refer to each other with formulas throughout. The first sheet is a block of data where I enter data into columns E, G, H, P, R, S, T, U and Y. Columns A, B, C, D, F, I, J, K, L, M, N, O, V, W and X all have formulas in them (many are VLOOKUP and some are calcul... 14 Apr 2010 15:34

Turning off whole word selection in Excel 2007
I want to turn OFF whole word selection in Excel 2007. I found the setting in Word and powerpoint, I even found the Application parameter in VBA. I can't find it in Excel. Does anyone know how to do this? ... 14 Apr 2010 13:20

GetSystemMetrics32(n) Question
I have found many articles on the web about the use of GetSystemMetrics(n) to determine the screen resolution by using n=0 and n=1. However, running the code: Declare Function GetSystemMetrics32 Lib "user32" _ Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long Sub x() Dim i As Long For i = 1 T... 14 Apr 2010 14:28

Need help with VBA help
On Thu, 11 Mar 2010 23:15:15 -0500, "Gary Keramidas" <gkeramidas(a)MSN.com> wrote: did you ever come up with a solution? YES!! Your fix worked perfectly!! Sorry for the long delay but I just tried the fix today. Now, I wonder why this was missing from the registry and why reinstalling Excel did not help. ... 14 Apr 2010 12:12

lookup list
I'd like to have a lookup list, which shows 2 colums of the reference table. The columns are next to each other. Is that possible? ... 14 Apr 2010 12:12