Excel Programming - Page 8599

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Rating Thread / Thread Starter	Last Post	Replies	Views
Passing a value to a variable from Userform by Neal Steiner Dear Most Valued Experts, I have a Userform where I am asking for information. In the code, when the user clicks OK, if the amount typed in is...	July 18th 03 09:12 PM by Neal[_2_]	1	69
DateLastModifed and Open File by Joseph Lam I'm trying to automatically format my report footers with certain information, one of the items being the last date of modification or save date. This is...	July 18th 03 09:03 PM by Ron de Bruin	1	45
Copying files ...Network to Network by Eric[_6_] Hi There, Can abody give me some tips on how to copy an excel files from network to network using macro (vba) commands. Appreciate anyone's...	July 18th 03 08:59 PM by Rob Bovey	2	55
Unlocking Cells by Sisilla The cell that is not being changed is my cell link for my drop-down. The other cells are being changed even if the sheet has been protected. I believe that...	July 18th 03 08:58 PM by Tom Ogilvy	1	51
Keeping original data format in a pivot table by Angelica Thomas I wrote a macro to convert my data into red, yellow, or green cell colors based on the value. Now I want to add a pivot table macro, but when I do that the...	July 18th 03 08:47 PM by Tom Ogilvy	1	137
Unlocking Cells by Tom Ogilvy You have defined names of SelectedFormulaRow and SelectedFormula Range("SelectedFormulaRow, SelectedFormula, G16, G18").Select Sub AAAA() ...	July 18th 03 08:46 PM by Tom Ogilvy	0	36
variables in last cell by josh this one is a little bit different this time, i need to output a variable from vba to the next available cell in a column in my worksheet, any help would be...	July 18th 03 08:38 PM by Tom Ogilvy	2	50
marco variables or substitution by Bob Phillips[_5_] Tim, Do a Replace. Hit Ctrl-H and type in the appropriate values. -- HTH -------	July 18th 03 08:36 PM by Bob Phillips[_5_]	0	43
Naming Worksheets in VBE by Don Guillett[_4_] in vba activesheet.name="NewName" -- Don Guillett SalesAid Software Granite Shoals, TX "tommy calahan" > wrote in...	July 18th 03 08:17 PM by Don Guillett[_4_]	0	50
Naming Worksheets in VBE by Chip Pearson Tommy, Try something like Worksheets("Sheet1").Name = "NewName" -- Cordially, Chip Pearson	July 18th 03 08:16 PM by Chip Pearson	0	45
Does destroying the ADO Connection close the database? by Bob Phillips[_5_] Tod, Is something happening here? If you see it open and then go away this seems to indicate all is okay, so why the question? Closing the connection will...	July 18th 03 08:04 PM by Bob Phillips[_5_]	0	39
column drag-and-drop by John A Grandy i am interested in the various column drag-and-drop solutions people may have come up with ....	July 18th 03 07:55 PM by Gord Dibben[_3_]	3	44
Highlighting 'corresponding' cells by R. Todd Miller I have a table like the one below. Is it possible to highlight an offset cell depending upon which cell is currently selected? In other words, if I click on...	July 18th 03 07:46 PM by R. Todd Miller	2	52
Does destroying the ADO Connection close the database? by Richard Choate Yes, that's pretty much it. Richard Choate "Tod" > wrote in message ... Here's my newbie ADO...	July 18th 03 07:45 PM by Richard Choate	0	40
Form output naming by Collings I would like to build a form in Excel and code VB to write the data to an output file. (which I feel confident that I can do), but I would like to tie the...	July 18th 03 07:43 PM by Chip Pearson	1	40
Excel Web Query by DM I am running into a problem with my web query. When ever I attempt to run a web query with a url that is greater than about 200 characters, the query fails....	July 18th 03 07:36 PM by Don Guillett[_4_]	1	64
cell color within a function by billQ Hello, Is it possible to change a cell interior color within a function or must that be done throught a sub. thanks billq	July 18th 03 07:36 PM by Bob Phillips[_5_]	3	51
Non-absolute named ranges by c t I have a multi column list, followed by a series of separate worksheets referring to the data in the different rows. If I sort the list, however, the...	July 18th 03 07:26 PM by c t	0	42
Close database if it is open by Tod I should know this by now, but what code do I use to test if a given Access database is open and close it if it is?	July 18th 03 07:19 PM by Tod	0	60
Formatting Problem on Double-Zero String by Tom Ogilvy If using xlWhole doesn't prevent this (which you say it doesn't) then try Sub Tester1() lFinalRow = 100 iFirstDataRow = 2 icol = 1 With...	July 18th 03 06:56 PM by Tim Childs	1	113

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed