General

Printing two columns of data in telephone directory style
Hi, Wondering if anyone can please help? I have a long (15,000 entry) list of data in two columns that I need to print. To save space, paper and access time, I'd like to print this list in two sets of two columns - as the names and numbers in a telephone directory might appear. What I envisage is my list... 9 Apr 2010 12:18

Forgot Password
Hi everyone. I have protected my worksheet formulas from anyone to view. Also I have protected my VBA code to view. And I forgot a password. I need to change a code in VBA. How can I crack these passwords ... 9 Apr 2010 08:54

How do I remove a Calculated Field from the Pivot Table fieldlist
Hi Second part first Select the field first from the dropdown>click Modify To get rid of a field, select the field from the dropdown>Delete -- Regards Roger Govier TheTraveler wrote: I have created two fields in my Pivot Table. However, the first one had an error in it. I tried to modify it, but w... 9 Apr 2010 05:38

Declare variables to a code?
I have the following code which deletes all rows older then 365 days: Sub Del_Oldies() LR = Cells(Rows.Count, 1).End(xlUp).Row For R = LR To 1 Step -1 If Date - Cells(R, 1) > 365 Then Cells(R, 1).EntireRow.Delete Next End Sub I keep getting error message Compile error: Variable not d... 10 Apr 2010 09:06

VB Help Needed
Can someone help me with the following code:- Sub SendEmail() Dim Email As String, Subj As String Dim Msg As String, URL As String Email = Range("A5") For Each c In Range("D7:D30") If c.Value = 0 Then SySname = c.Offset(, -3).Value Subj = SySname Msg = "" Msg = Msg & ... 9 Apr 2010 04:33

rewrite code
Hi, I sthere a way I can tidy this part of my code up to run more better. Sub MyCopy() Range("O7:P16").Copy Range("A7:B7").Select ActiveSheet.Paste Range("Q7:R16").Copy Range("F7:G7").Select ActiveSheet.Paste Range("O18:P27").Copy Range("A24:B24").Select ActiveSheet.Paste ... 9 Apr 2010 05:38

Move Form to edge of chart window
I am using some vba in excel to display different forms in different sheets. Workbook has one data entry sheet with a dedicated form. This I manage to select as I have info on the screen resolution even if it changes and by selecting a particlar cell I manage to move this form relative to this cell. The probl... 9 Apr 2010 03:27

Userform modal
I have created Userforms for timesheets with different projects appearing on a Multi page Userform. The problem is I need to show the subtotals on another Userform as the user inputs the data. i've tried everything but I can't get it to work ... 9 Apr 2010 03:27

Vlookup with difference between two data
Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP Range 2. Result. Question: EG:IP Range Start IP End IP Area 192.168.1.4 ... 9 Apr 2010 01:16

how do I email excell
How do I send an email from Excell?l ... 9 Apr 2010 08:54