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

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