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