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 163 164 165 166 167 168 169 170 171 172 173 174

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