PDA

View Full Version : Excel Programming


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 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309

  1. Application.Onkey With SPACEBAR
  2. conditionally formatting a range using VB
  3. Emailing from notes: pasting values into mail body
  4. Macro delete + confirm deletion
  5. Use Excel to replace in Word
  6. HTML doc saved in file
  7. Select specif range on Conditional Format
  8. vba code terminates without error
  9. Extract strings intelligently from single cell
  10. Deleting Specific Rows
  11. Transfer values to master sheet
  12. Entire Mail Merge in Excel
  13. summing data writen by a excel vba form
  14. Sumproduct? Countif?
  15. Disable copy/paste
  16. Move Blocks Of Data In Columns To Rows
  17. create a simple macro that changes fill color
  18. Exit cell macro
  19. How to add rows to list automatically
  20. How can I select printer drawer?
  21. VBA Match or Find code
  22. Auto Date & Time Stamp
  23. VBA solver
  24. Calculate Total Time when Dates/Times Overlap
  25. Hiding rows
  26. Copy from 1 sheet to another
  27. Programming Question
  28. pasting values into EMPTY cells
  29. Random
  30. Remove Certain Last Words from String
  31. Can I place a function call withing SQL Statements?
  32. Distribute Data to Multiple Worksheets
  33. Populate Web Form Dropdown
  34. Finding max -
  35. Lookup in various ranges, return maximum value
  36. Search and return values in a range Group
  37. Last used Column
  38. Macro In Standard Menu Bar Drop Down
  39. macro to copy existing sheets
  40. Find/Replace in formulas
  41. When do I use the NEW keyword
  42. Progammatically Add/Modify the Validation
  43. time to get ruthless
  44. time to get ruthless
  45. Full File Path in footer in ALL workbooks
  46. Application.Onkey Assistance
  47. cell data too large
  48. Calculation Setting to Manual
  49. For i Searching for <> several criteria
  50. Tying sheets and Automatic Age Counting
  51. Using Excel Data to Populate an Access Table
  52. Dice Possible Outcomes Macro / Formula?
  53. Positioning and modifying a chart
  54. Merge Cells
  55. Private Sub Worksheet_Change
  56. Interpolation
  57. Using Excel Formula in VBA
  58. To know if the shared workbook is used by anybody
  59. search function but how do i make it select the entire row
  60. Events
  61. Tweaking VBA Code for HTML Table Cell Reading
  62. Error Handling with Multiple Errors
  63. Blackberry Friendly report automated
  64. How do i copy data out of a drop down box to a cell?
  65. Solver calculation problem
  66. Copy different columns from multiple worksheets into 1 worksheet
  67. code to work on displaying date automatically
  68. PERSONAL.XLS and $%&*(& sheet that won't go away
  69. wildcard in Application.GetOpenFilename
  70. Auto format cells
  71. Hiding/Displaying Cells based off input box value
  72. Match 2 worksheets
  73. Renaming worksheet question
  74. Text formatting
  75. stop the message box code
  76. Error Number 55 (File Already Open)
  77. WorkSheet_Change problem
  78. vba code for date matching
  79. Message Box when 2 Cell values equal
  80. Find Criteria, Delete rows above and below
  81. Page-setup in vb?
  82. Saving userform data to another worksheet
  83. Cell Value In User Form
  84. autofilter to hide columns
  85. excel error
  86. Code to capture recalculated cells - "Date last modified" utility
  87. Vba -security level
  88. Conditionall format entire workbook with VBA
  89. Search for results in a separate spreadsheet
  90. macro loop
  91. Coloring rows based on criteria
  92. Help on 3 Codes to get me started
  93. Importing data with ExcelVBA
  94. Clearing cells using VBA
  95. Pivot Page Field Macro Works, but pivot not updating
  96. Security in Excel 2003 Macro
  97. Userform with Checkboxes error
  98. Macro problem with GETPIVOTDATA
  99. Adding sick occurances in a rolling year
  100. Macro to Search, Copy/Paste onto New Sheet
  101. Label to display current Date, Time
  102. Userform initialize
  103. Macro to drill down for pivot table
  104. Autofilter - Sum visible cells
  105. mouseover ??
  106. Programming an alarm clock
  107. Selecting Active Rows after autofiltering copy, pasting and deleting
  108. Open a folder and delete contents Macro
  109. e-mail certain ranges from a worksheet
  110. Generat email from excel
  111. Copying rows based upon 3 text strings
  112. Code that Varies
  113. Find cells of a specific colour and delete value
  114. Entering data every 14th column across sheets
  115. copy columns from 1 workbooks to another
  116. Message box
  117. Counting number of times a Text pattern appeared in a range
  118. table to show the average price macro
  119. Copy rows gives wrong formulas
  120. Convert Excel worksheets to pdf
  121. Coloring a cell
  122. Automatically send Excel document in Outlook
  123. csv extract
  124. Creating Macro for Individual Tab/Chart Creation
  125. File List Box
  126. Multiple Matching
  127. Saving a page in PDF
  128. Add multiple spreadsheets to single spreadsheet
  129. macro export
  130. Importing an excel worksheet
  131. Excel
  132. Improve login process
  133. Date format
  134. Select method of range class error?
  135. YTD total but really showing the Current Month data
  136. copying data using a macro
  137. link text in msg box
  138. How to MACRO????
  139. Adding library references with code -> error 1004
  140. Conditional formatting and text alignment
  141. Lock rows by condition
  142. Dynamically view and alter records
  143. Worksheet_Deactivate procedure leaves me on the deactivated sheet
  144. Match & combine
  145. Msg box to appear when printing
  146. Search and Add to List
  147. Scrolling question
  148. Checkbox in MsgBox
  149. button in userform and "i"
  150. Loop For not working properly
  151. Formula in Range Union!!
  152. Scoring Macro
  153. Macro retreiving data from SQL database through Access Linked tables and queries
  154. Seperate Tab Macro
  155. sheet shifts up/down
  156. Insert Formulas in Cell according to conditions
  157. Search for file in directory
  158. Stop some sheets from being calculated
  159. Compiling from individual to family data
  160. Extracting Data that got Eliminated or Added
  161. Question regarding eliminating empty cells or cells with zeros
  162. Capturing the Excel AutoFilter Sorting Event
  163. Range select
  164. MD5 Hash
  165. Initialize or Assign Array Values
  166. Find last row in a "specific" column
  167. Search and Update List using Macro
  168. Sorting and Summing
  169. Dim Variable work-around
  170. Copying values into the next row
  171. Extracting Numbers from text String and Sum?
  172. Ontime Macro
  173. All the 4 character combinations possible from ABCDEFGHILMNOPRST?
  174. extracting page number from page setup footer
  175. Copy excel info to Word
  176. making a calculator from vb.net to vba
  177. Timed Trigger of a Macro
  178. How to trigger code execution?
  179. Line Chart values to appear in a cell
  180. Lookup, Edit and Replace the Row?
  181. Clear a collection
  182. Search Spreadsheet from a form
  183. code to copy a specified text in excel cell
  184. More practicality of the code!
  185. Remove duplicates from 1 dimensional array in VBA
  186. Date picker
  187. Check or Uncheck range of cells
  188. Alternative Code - Nested Ifs
  189. Date Truncation
  190. Workbook Open macro issue
  191. Copy Values across Network Directories
  192. Column Total
  193. Clip board Data
  194. sorting data
  195. VBA for edit mode
  196. Macro for renaming sheets
  197. Getting associated cells in a worksheet based on Combobox
  198. Time difference
  199. Deleting Raw Data = Deleting Pivot Tables?
  200. Keyword Formula (Files Attached)
  201. index,match and sum question
  202. List all the combinations of a group of cells containing letters, but not numbers
  203. cells into array
  204. Toggle Code to format-unformat range of cells
  205. Error Handling with Multiple Errors
  206. extract last three words from sentence
  207. command buttons
  208. Column Display Manipulation
  209. macro to insert blank line at end of date series
  210. Deleting Sheets Macro
  211. Writing a function that finds the numbers that make up a total
  212. macro referring to a cell that contains a formula
  213. Activating Worksheet after Loading Modeless UserForm
  214. Digital Signatures -Is hacking a reasonable concern?
  215. macro to copy and paste data
  216. Shortening up Code
  217. List files in a folder
  218. Loopiing issue
  219. Renaming Worksheet and Skipping a Cell
  220. Automation error when creating graphs
  221. Setting print area by name and not cells with any value in
  222. Start Macro When Workbook Opens?
  223. conditional formatting problem
  224. Speed up row delete
  225. Pulling in Active Directory Fields
  226. Running a macro on opening a file
  227. formulae one sheet that appears in all new sheets
  228. Small problem with Database example from RoyUK
  229. Combobox making excel freeze
  230. Preventing Duplicates
  231. Close word without saving
  232. Issues pasting in column B and making 2nd macro available
  233. data validation updating
  234. .Range cant take long argument
  235. Conditional formatting problem
  236. Summing By Text Criteria
  237. Export Excel data as bulleted text in Word
  238. Checking for Open Workbook
  239. Macro to enter a shape with text and macro
  240. Page breaks added to existing print macro
  241. Deleting rows that dosent match the criteria
  242. Updating data lists via outside table source
  243. Reset formula in macro
  244. Taking info from chart and transposing to timeline.
  245. "Find" Button
  246. 'Group by' in excel
  247. Tracking Users Who Change a Worksheet
  248. How to put a button on a cell and assign macro to it?
  249. Data Compile
  250. How to add an "accept terms" option before opening another worksheet?