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