PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 [33] 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162

  1. Closing Excel..
  2. Help with a while wend loop
  3. Getting Weekday as String and working with dates
  4. Freezing two top rows
  5. Adding text to existing text
  6. Solved: Assist in Converting IF-Then to Select Case
  7. Error Handling: Complete exit
  8. Buggy scope of a variable
  9. Pivot table macro
  10. Highlight row if date is this week
  11. Disable menu options
  12. Solved: Using Object Browser: Discover New Info
  13. Returning to Excel from Paste in Word
  14. Commenting code
  15. Get File Extension
  16. Running a macro when excel startsup
  17. Solved: Excel/Word timing problem
  18. Rename Multiple files. Help wanted
  19. Calling Word macro from Excel macro
  20. Excel 2007 Multiplication Bug?!
  21. Solved: Close all instances of IE
  22. Not sure how to Amend current VBA code to do one more step
  23. Excel Add ins - Free Ones
  24. Setting values to a whole range at once
  25. Solved: How to call an action based on input
  26. Solved: Loops and linking to Internet Explorer Excel file
  27. Solved: Prevent Delete of Certain Sheets
  28. Solved: Deleting group of rows if string pattern doesnt match
  29. Change empty cell to a character in VBA
  30. output to textfile
  31. Need a function to convert mm to inches
  32. Critical Error: Odd Behavior on This particular Line all day
  33. Solved: Multiple Pivot Tables - simultaneous field change
  34. Holiday planner/tracker
  35. Solved: Code execution interrupted
  36. Amend code -
  37. Check for active Word document
  38. Add records to table (excel)
  39. Solved: Insert Rows and Transpose
  40. Pivot Table Settings
  41. Shorter way of putting names to SeriesCollection
  42. Delete unmatched records
  43. Solved: Excel 2007 Multiplication Bug Da Capo...
  44. Paste Special?
  45. convert a number into month
  46. Count --> all worksheets
  47. WORKDAY function
  48. Solved: Changing text in multiple cells
  49. Solved: string problem
  50. VBA - conditional formatting on several sheets
  51. Solved: Copy works, copy/paste doesn't... (bug?)
  52. Solved: Excel 2007 viewer
  53. Send Key function help
  54. Copying an entire sheet into another workbook
  55. "Unable to get the Find property of the range class" Error
  56. Stopwatch in Excel !!!!
  57. Solved: Pass Variable Reference
  58. a list of all formula in activeworkbook
  59. Solved: Non-Contiguous Copy PasteSpecial
  60. Auto fill a form
  61. Solved: Creating new worksheets
  62. Solved: type mismatch on open
  63. A Free ebook on Excel from MrExcel.com
  64. Solved: Pass a workbook and worksheet name
  65. Solved: Shapes: Some Explanation Please
  66. Why does Object Browser Show Same Items Multiple Times?
  67. select case and looping problem
  68. Solved: VBA beginner exercise
  69. question on 'Install or Uninstall ActiveX Controls (.ocx, .dll files)'
  70. Solved: Cell Arrangement
  71. How to search for phonetic similarities in Addresses
  72. unsort after sort
  73. How to remove everything but one sheet?
  74. Shortcut to inserting rows
  75. Solved: UDF to emulate Weeknum()
  76. Solved: Why do my URL's change after saving a workbook?
  77. Batch file execution
  78. How to skip the cell?
  79. Hide Rows based several values
  80. Disable Macro Security by VBA
  81. conditonal formatting
  82. Solved: Deleting Rows if a particular string doesnt exist in it
  83. Userform to change password in VBE
  84. Postcode Macro - Amending
  85. AD lastLogonTimestamp Is my code right?
  86. How to copy two non-contiguous cells
  87. Left and Find Function Syntax
  88. Solved: Activating a worksheet whose name is customized
  89. Solved: SumProduct vs. SUM ??
  90. Solved: Deleting Rows
  91. Solved: IsBlank? Missing Library?
  92. inputbox help wanted
  93. Help appreciated
  94. Function to replace formulas
  95. Attention all Excel Experts
  96. Sheets Object problem
  97. Non-contiguous ranges (different sheets!)
  98. Function macro
  99. Solved: INSERT CELL COMMENTS IN PROTECTED SHEET
  100. VBA & Save File name HELP!
  101. array
  102. Open Multiple Files & Paste Data
  103. Solved: Importing data file into spreadsheet
  104. Date Problem
  105. Another one for the Experts
  106. VBA: Summing up a variable length row using ActiveCell.Formula
  107. Batch file
  108. Solved: Calling subroutine
  109. Solved: Sum Function
  110. Exit Sub w/out Error when Cancelling Routine
  111. Problems using if-then in direct window
  112. Solved: MisMatch error on joining two statements
  113. OptionButton madness...
  114. Memory issues (#7)
  115. set range conditional on the numbers of rows
  116. Solved: Delete same row from multiple sheets
  117. Error Handler
  118. Find last row, Offset
  119. Learning VBA - is this a good starter project?
  120. Show and Hide Label
  121. formatting cell or using functions to remove text from cell A into cell B
  122. Row Delete
  123. Solved: line continuation on formula?
  124. Solved: Complicated calculations
  125. Solved: What data type is this?
  126. Code Change
  127. Solved: Copy column "A" to column "Q"
  128. Percentages
  129. Solved: I can?t copy formula as text from one sheet to another.
  130. sum visible cells
  131. Solved: Trigger a Macro with a hyperlink
  132. Data Distribution
  133. Solved: Format(i, "00") works in 2003, bad in '07
  134. Solved: Quickie- Explanation Properties/Objects
  135. formatting & updating a group textboxes
  136. Copy Data from Excel to Access, via Excel VBA
  137. Solved: Extracting cell addresses from a formula
  138. Pivot Table Group Months Year
  139. Code in IE's Close event
  140. MsgBox
  141. Solved: finding last row w/ (xldown)
  142. Error Msg: vba code execution has been interrupted
  143. Solved: Class Modules??
  144. Subscript out of range
  145. Filldown a vlookup with no fixed start point
  146. 2nd persistant messagebox occuring
  147. Excel can't find path
  148. Looping a macro to run at each change in variable
  149. forms and modules
  150. Option Buttons
  151. Formula from VBA doesn't work
  152. How to select & open latest time stamp workbook
  153. Copy & Paste ranges from multiple worksheets
  154. Auto SAve
  155. Solved: deleting rows again
  156. Solved: With-End With problem
  157. forms & multipage forms
  158. wipe up MACRO code when WorkBooks Expire
  159. for....next
  160. Using variable to define a range
  161. code to copy the contents
  162. Solved: Using Offset w/ rng variable
  163. CountIF
  164. Solved: Protect columnn widths
  165. Creating a Master Spreadsheet
  166. Solved: Check Value of Array
  167. Solved: Re-use Automation Object Variables vs. release and re-Create
  168. list all excel files in a folder
  169. Date Format
  170. default sort behavior?
  171. Cleaner VBA? - Building Array of Months (Fiscal Year)
  172. Limiting the no of times a macro can run
  173. Defining constants
  174. Autofitting columns with a condition
  175. Confusion about giving a chart a title
  176. Solved: Extract Excel Files from Outlook
  177. macro - pivot table
  178. Solved: Force characters in text box
  179. Solved: Use Offset to return a value
  180. Solved: Range Select from Found Cell
  181. Solved: Userform With Dropdown Selection
  182. Solved: Variant List
  183. Solved: [Solved]Copying contents of textbox to clipboard
  184. Solved: Date Difference YY-MM-WW-DD-HH-MM-SS
  185. Delete Hidden Name Ranges
  186. Accessing a macro in a locked project in another book.
  187. Solved: Searching for multiple values within cell
  188. Using option button properties
  189. Solved: Split large data in various sheets
  190. Solved: Is there a faster way to move these cells
  191. Data Extract from CSV File with date filter
  192. prompt
  193. Help programing an Excel Document
  194. Solved: Selection of columns and clearing values
  195. Alter colour of cell text based on value of cell next to it?
  196. Find "-n-t" in a string and skip it!
  197. Solved: User form- Need grayed-out options
  198. Solved: .Find for empty string
  199. Changing Printers and page sizes in Excel
  200. Solved: Menu maker
  201. Urgent help in VBA for averaging data
  202. Solved: Problem with macro containing Vlookup - error handling??
  203. Using XMLHTTPRequest within Firefox
  204. Solved: Highlight Row Based on Column Criteria
  205. Solved: VBA formatting
  206. Accessing a control in another (non-Office) application
  207. Eliminate noise in data points
  208. Solved: Counting colors
  209. find a way to copy link
  210. Text to column with line breaks
  211. How to add items to a combo box upon start?
  212. Save some sheets with name
  213. Solved: How to find the same numbers between two numbers
  214. For Each / Next Problem
  215. Solved: SELECT CERTAIN COLUMN BASED ON IF DATE BETWEEN
  216. Solved: Scroll Sheet Whilst Userform Active
  217. Solved: How to unprotect sheet in Excel in other program?
  218. Solved: Copy worksheets with msg box
  219. Custom validation
  220. Not able to enter a formula in a cell
  221. Quirk with Cond Formatting?
  222. Text box/userform - 2DP?
  223. Solved: send email from Excel with cells as body
  224. US UK Date format issue
  225. Worksheet with alternative calculation methods
  226. fill down code help
  227. Solved: repeat macro set number of times
  228. Solved: a "Sorting" Macro
  229. check credit cards
  230. Select first Item in Listbox
  231. Arrays and Accessing Elements by Index
  232. Factorial Subroutine
  233. Solved: Delete information in a cell which also exist in another cell
  234. Solved: hide/unhide rows based on value of target cell
  235. Excel select data from mess
  236. Solved: Zoom and Setting Column Sizes
  237. Solved: Preserve sheets before Macros Runs
  238. activate original window at end of macro?
  239. mail a workbook
  240. Formula / Memory Limitations?
  241. Solved: Solved - Help to build a function to detect Captial Letters in a Cell
  242. Arrays, one works one doesnt.
  243. How to enter a formula in Excel via VBA .Formula properity?
  244. Solved: Get functions list in Worksheet
  245. Solved: Convert with INDIRECT function
  246. Solved: Open pdf file into Excel
  247. Solved: Create short name
  248. Macro to tel user new data has been added
  249. Solved: How to select top three visible results?
  250. translating languages with vba