Programming

Copy-Pasting row into exact same row on specific other worksheets
Good morning I have just finished writing a vba code that inserts a row into a worksheet and then fills in values based on user input. Now, what I need to occur is once this process is done, for the row to be copied, and to insert the copied row into the exact row number on three specific other worksheets. ... 1 Apr 2010 06:49

Button to take the user in a different place on the same sheet
Hello, I have a command button (Button 4585). I would like it to take the user to another place (cells A147:A180) on the same sheet (Sheet 10). Is this possible? I cannot just use a hyperlink on a cell as the button only becomes visible if the user makes certain choices. Thanks very much in advance. Joha... 1 Apr 2010 11:16

How to re-fresh the import links if it fails?
I would like to retry 5 times to retrieve data from import links if it fails to be retrieved. Does anyone have any suggestions on how to refresh the import links if it fails? Thanks in advance for any suggestions Eric ------------------------------------------------------------------------------------------ Dim ... 1 Apr 2010 04:40

Alpha Numeric’s bunch together
Hi, When I type code the alpha numeric's sometimes bunch together and the font changes to red as in the case below. As in For i =1To2 and Nexti . Sub CopyDemand() Dim i As Integer For i =1To2 Sheets("Demand").Select ActiveCell.Offset(0, 2).Activate ActiveCell.Copy Sheets("Demand1"... 1 Apr 2010 01:27

Macro for changing number of rows
Hello - So I'm a little less experienced than I thought. Below is my table. Item Rate 1 Rate 2 A 0.60% 0.30% B 0.50% 0.40% C 0.50% 0.70% E 0.30% 0.30% F 0.20% 0.50% Below is my Macro: Sub Ordering_Macro() ' ' Ordering_Macro Macro ' ' ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.... 31 Mar 2010 23:16

Need To Protect "Tab code"
I have code within a tab, for example a "Private Sub Worksheet_SelectionChange...". I was suprised that although I PROTECT the worksheet with a password, the code within the tab is still accessible and be modified. How can this too be protected from anyone updating it? ... 1 Apr 2010 09:03

Loading Data into MultiPage UserForm
Good evening: I am a novice at VBA, though have written some code through trial and error. I now am trying to find the best way to fill combo and list boxes on a multi-page (3 page) form with boxes on each page. I assume this would best be done in the form_initialize code, but I'm struggling with the process... 31 Mar 2010 21:04

Move cells down to match cells
A portion of my spreadsheet looks like this: A B C D E 1 000801025-8 009601025-3 2007 000801025-8 2007 2 000801026-9 009601026-4 2004 000801026-9 2004 3 000801028-1 009601028-6 2006 000801028-1 2006 4 000801036-8 009601036-3 2008 000801036-8 200... 1 Apr 2010 14:39

Move cells down to match cells
A B C D E 1 000801025-8 009601025-3 2007 000801025-8 2007 2 000801026-9 009601026-4 2004 000801026-9 2004 3 000801028-1 009601028-6 2006 000801028-1 2006 4 000801036-8 009601036-3 2008 000801036-8 2008 5 000801044-5 009601044-0 2007 000801044-5 ... 31 Mar 2010 17:44

Move to match cells
A B C D E 1 000801025-8 009601025-3 2007 000801025-8 2007 2 000801026-9 009601026-4 2004 000801026-9 2004 3 000801028-1 009601028-6 2006 000801028-1 2006 4 000801036-8 009601036-3 2008 000801036-8 2008 5 000801044-5 009601044-0 2007 000801044-5 2007... 31 Mar 2010 17:44