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

  1. Recommend Books for VBA, Excel, and Access.
  2. Solved: erase blanks
  3. Solved: Macro to close all windows but one
  4. need help with coding
  5. Web Toolbar
  6. Quick Subtotal Question
  7. Solved: Pivot table (XLD)
  8. Solved: Copy cell range, paste into Outlook Contact Notes
  9. [SOLVED] Coding alternating blank lines w emails
  10. Solved: Retrieve Outlook Contact Data
  11. Solved: SumProduct
  12. Solved: fso.GetFile not working!
  13. Solved: Default file
  14. Solved: worksheet buttons
  15. Solved: Shape colour
  16. Calender Control
  17. how to eliminate Ist column
  18. Hide 2 of 3 Pivot Chart Buttons?
  19. match variable with list
  20. VBA Excel Project
  21. Solved: Generating Unique Number ID's
  22. Solved: Chart. Very different value. SpinButton
  23. manipulating userform objects from a code module
  24. Solved: Adding to values together within a cell programatically
  25. Solved: Vlookup Question
  26. Solved: Sumproduct problem in table
  27. Solved: How to capture cell changes
  28. Solved: SUMIF "CELL IS NOT NULL"
  29. Solved: Hello all, a little help needed if possible...
  30. why i am having run time error with this code
  31. Solved: Copy worksheer to all workbooks in specified folder
  32. How to group all sheets by default
  33. Solved: Find text & Mark findings
  34. Paste into a comment box directly from clipboard?
  35. Solved: Passing a module as a parameter
  36. Select and copy every second row
  37. Solved: Move rows to new work book based on a cell value.
  38. Solved: Protecting Custom Properties
  39. Solved: Formula for Conditional Formatting
  40. Compare and delele cells with equal value
  41. Solved: How do I activate an Outlook dialog box, make selection, then return to Excel?
  42. Solved: CAPS LOCK Balloon Message
  43. Solved: User name
  44. Adding Continuous Check Boxes
  45. pivot tables
  46. Converting XLS file into CSV file
  47. Solved: Find row number and pass it to a variable
  48. vba excel code to find current dll running
  49. Create a single .csv from multiple worksheets
  50. Solved: Trying to compare two columns
  51. Solved: printing worksheet
  52. Solved: Sorting Cells with Empty Strings
  53. File Save User Form
  54. Solved: save combobox selection to worksheet
  55. DisableAutoMacros when opening Word in Excel VBA
  56. VBA coding to run macro on multiple files
  57. Solved: Call a Userform when "Esc" key is press
  58. ok
  59. Retreiving tab name
  60. Solved: Applying a countif formula to each section of data in excel worksheet
  61. VBA Coding for function that has multiple Integer Value
  62. Alternative To ActiveCell.Row
  63. Solved: using outlook dialog boxes in excel
  64. Shopping Basket Analysis
  65. Copy a file
  66. Solved: No warning when overwriting file
  67. scheduling a macro a once a week
  68. How many characters can countif handle?
  69. date format and filtering
  70. Solved: How to resolve out of subscript range error?
  71. XLS size restriction?
  72. Solved: Writing UserForm data to a Specific cell
  73. Remove Tool Bar in Chart Sheet
  74. Right mouse click on user form
  75. Finding VBA and Function code
  76. Cell Contains Word
  77. Solved: Userform/sheet selection
  78. Need help deciphering code
  79. [SOLVED] Use of File Array in Excel VBA
  80. Solved: Code to find match & remove data from 5 sheets
  81. How to identify workbook?s name?
  82. Solved: Alter code to only copy values without formulas
  83. Solved: vba code for adding same row next column if condition met
  84. Solved: wildcards for not contain
  85. Solved: adding a Month
  86. Working With Multiple Workbooks
  87. UserForm
  88. limited period
  89. pasting range .offset
  90. Solved: for loop
  91. Solved: Save dates for weekly figures
  92. Between --- in excel?
  93. Solved: Use Command button to e-mail from userform
  94. [SOLVED] Change Data for Chart via dropdown
  95. Userform/sheet selection again
  96. Problems running macro from another workbook
  97. VBA - Changing SeriesCollection.Values for Line Chart
  98. Import data
  99. VBA Set PivotItem to Not Visible
  100. Solved: Quit Application if filename is renamed
  101. Solved: Combining macros to open and run on multiple protected worksheets
  102. Moving an Entire Line using ActiveCell.Row
  103. Dragging Listbox Items within same listbox up/down
  104. Prevent Save, enable SaveAs with default file name
  105. Solved: VBA for Concatenate
  106. VBA: Insert cells without affecting formulas
  107. Solved: Adding only certain values within a cell
  108. Solved: Extracting Data Based on Date Range
  109. Solved: Turning an m*n matrices into m*n rows
  110. add multiple array to combobx
  111. Macro to open workbook read only
  112. Solved: Passing a variable
  113. Solved: Error With Code (Compile Error) ~Excel 97~
  114. Please help with the simple loop
  115. Solved: N Dimension Arrays
  116. VBA Web query newbie problem
  117. Transfer Listbox Rowsource to Worksheet Range
  118. Addin wants password when exiting Excel
  119. export excel to outlook
  120. Dealing with worksheet insert error
  121. Exit sub issues
  122. Passing variable to UserForm textbox effort
  123. Solved: date and time score as text
  124. Macro fills in blank cells with formula stops at endrow
  125. Solved: referencing a sheet and cell
  126. Solved: Alter code to clear contents not delete row.
  127. Solved: VBA function to return hyperlink
  128. Solved: Userform combobox macro to make autosort
  129. Code to delete all modules
  130. Excel-Access Question
  131. Consolidating multiple series in worksheet by Date field
  132. Auto compress pictures
  133. align email body from excel
  134. Macro not pasting to correct place
  135. Managing large numbers of buttons
  136. Filter validation list
  137. Urgent - aligning text to the right
  138. Sharing a Variable
  139. Need help with Button command
  140. Align a picture in the center of the screen using VBA
  141. Excel Custom Properties
  142. Calculating Averages
  143. Solved: need help with command button
  144. Any workaround for assigning values to multiple cells by excel formula or function
  145. charts and data table
  146. Solved: count rows excluding header row
  147. Solved: scrollbar.width property problem on other computers
  148. Macro stops when criteria not met
  149. Template and SaveAsUI
  150. Solved: Button Command Challenging
  151. Create Summary Sheet then export that to a Master Workbook
  152. Update a cell with another cell
  153. Excel 2007 Removing a Custom Tab and Ribbon
  154. Trouble with vlookup
  155. Solved: assigning values to variable using loops
  156. Quick question about Application.GetOpenFilename()
  157. Solved: Workbook Event CODE
  158. Notepad to xls
  159. Workbook_BeforeClose and Workbook_Deactivate
  160. Provide option to disable macros
  161. Vlookup help
  162. Copy & Paste
  163. Scripting dictionary
  164. Solved: Creating a data tree in the worksheet
  165. Solved: Changing the printer designation for each user
  166. Copy data from one workbook to another!
  167. How do I change ?i? as an integer (ie 1,2,3,4?) to ?i? (1-10) with intervals of 0.1?
  168. Solved: Blanks and bad characters
  169. Solved: Paste on grouped sheets in VB for Excel
  170. Macro to Protect formula cells
  171. array sum
  172. Solved: password recover?
  173. Get all cells in a column
  174. usinig netdays in an "if then" code
  175. Solved: Download with UserForm
  176. Solved: Error when referencing 3 ranges with a variable
  177. Default Value in Combobox
  178. Sumproduct help
  179. help with code for conditional summary sheet
  180. Solved: Close workbook
  181. Solved: Excel in-formula macro help!
  182. Solved: Excel Pasting doesn't align to Word Bookmark
  183. Moving Charts in Excel Worksheet
  184. Range that increments column number
  185. Solved: Computing Average Using Offset
  186. intra portfolio correlation formula in vba
  187. Close Workbook and Show Userform
  188. Solved: VBA to delete all "unused" formulas
  189. Building a data base from Real-Time Data
  190. Return text in cell based on match of multiple criteria
  191. Solved: Import HTML Query Named range issue
  192. Named Ranges
  193. Solved: Saving worksheets as separate workbooks
  194. Double Click
  195. Create an access database by a VBA in Excel
  196. Solved: chart sheet and work sheet
  197. Solved: Problem initializing Class after adding an ActiveX control
  198. Solved: Date Format in UserForm
  199. Solved: Excel data to Word bookmarks
  200. Solved: Help please...input box issue...
  201. Error handler not working
  202. Data Range Issue
  203. Inserting default character(s) when submit button is pressed
  204. Wont let me select range
  205. Runtime error while using Advanced filter
  206. Solved: How the Code Works?
  207. Paste Named Range
  208. Solved: Code to check that a worksheet name from an inputbox is valid?
  209. How to make this VBA better
  210. Solved: Pop up errors/boxes when running macro
  211. Understanding Multi Column Listbox
  212. get particular data from outlook mail into excel using VBA
  213. Creating a macro to copy formulas
  214. Install addin for everyone
  215. Solved: Assistance With a ComboBox
  216. Deleting rows, adding columns and Excel formulas
  217. Soooo Sloooow!
  218. Context specific help (WhatsThisHelp)
  219. Solved: Fastest way to divide all rows in column C by a fixed number, put results in column D
  220. Getting Unique elements of Array
  221. generate matrix from table?
  222. Solved: VBE to change Line Chart Height based on number of Rows
  223. Building a hierarchy
  224. how to get the language installation
  225. Solved: Do I need SUMIF for this problem?
  226. Solved: password to modify
  227. Solved: Moving Copying and Deleting A Sheet
  228. Summing all rows in a column in a specified worksheet
  229. Highlighting filtered columns - automatically
  230. Solved: Update Recordset from VBA Not Working
  231. Solved: Do loop problem is last row (65536) reached
  232. Solved: end if without block if?
  233. Solved: Macro won't loop to second worksheet
  234. Solved: How can I test a Form Label to see if it is contained in a given Form Frame?
  235. Solved: Cut a Long list in half and paste into a new Column
  236. Solved: Data Validation: Drop-Down Text Size
  237. Solved: Macro to find code in many columns and copy findings (not easy)
  238. Pasting Special Cell into different sheet
  239. Solved: Solved....Locking Cells?
  240. Help button to open pdf or chm
  241. IE Automation form Javascript
  242. Custom Pivot Table Drilldowns in Excel 2007
  243. Run code on workbook open
  244. Tab Order
  245. dictionary userform
  246. Exporting data to Outlook Calendar
  247. Solved: Help using the RefEdit Control
  248. Solved: Looping through workbooks instead of worksheet
  249. select/use active pivot, vba
  250. Code crashes when closing workbook