First  |  Prev |  Next  |  Last
Pages: 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192
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 ... 9 Apr 2010 01:16
how do I email excell
How do I send an email from Excell?l ... 9 Apr 2010 08:54
First  |  Prev |  Next  |  Last
Pages: 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192