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. How to splitt texts into words? (collecting word and compounds)
  2. Averaging two different places within sheet
  3. Macro that allows selects the same cell on every sheet.
  4. User Form Validation
  5. Search The Worksheet
  6. Run macro for all files in a folder
  7. Accessing Message Editor Of Web Based Email
  8. Conditional formatting from separate pages
  9. "Compile error in hidden module: module1"
  10. Triggering a loop within a loop
  11. Force, or simulate a procedure error for testing
  12. macro to copy data and paste to new worksheet
  13. Do Not Pull Date Numbers
  14. Dim Lastrow ? Dim LastColumn
  15. Dynamic Ranges
  16. Select Method of Range Class Failed..for no reason!
  17. identify defined names in VBA code
  18. Transposing data ,, the big move
  19. RexEx to extract from middle or end of string
  20. Auto sort in sheet 2/3 based on sheet1 Data
  21. print button
  22. range Value
  23. Using Autofill with Destination Parameter as a Variable
  24. Formulas - count the amount of working weeks from a date until present date
  25. If statements that has #NA
  26. How to increase speed in Excel processing
  27. VBA and Screen video resolution
  28. form calendar control
  29. How to use Update function using Macro..???
  30. How to freeze panes through VBA?
  31. Updating cells based on corresponding cells
  32. Changing Text Color per row.
  33. #VALUE! Error
  34. Searching through a sheet
  35. Copying all data from multiple tabbed sheets to another worksheet
  36. Change entered number to negative
  37. Range Name Conflicts
  38. Import an Access Table
  39. 'Tell' excel not to auto increment cell reference?
  40. Circular reference
  41. Cell comparison with Threshold
  42. Website XLS
  43. Macro for time format...
  44. On mouse over, or similar macro?
  45. Creating A New Folder With Current Date
  46. Transfering data between tabs using code.
  47. retrieve data from Microsoft word
  48. Automating entries between sheets?
  49. Separating first & last names using formulas
  50. Pulling data from one workbook into another
  51. Removing blank lines when copying from one sheet to another.
  52. Code error
  53. Combining two files using Macro in MS Excel 2007
  54. Macro to copy rows
  55. Dictionary Object
  56. Referencing a specific cell after found using VB code
  57. Automated data selection ???
  58. how do you make a macro inside the default template
  59. Application-defined or object-defined error
  60. Replace numbers with Text ("1" to "Apple", for example)
  61. Compare columns and move to different worksheet
  62. Efficient logic to deal with large files
  63. can i create a popup window in excel
  64. DAOCopyFromRecordSet Timecards
  65. Multiple conditions in one IF statement
  66. Selecting Range next to ActiveCell
  67. How to simulate Control (button) and Mouse Selection of
  68. Command Button Face is Disappearing
  69. Macro to fill in blank cells
  70. Changing rowsource of 2 listboxes based on 3rd listbox.
  71. Lotus Notes Attachment vs Embedded Object
  72. copy of last three cells of each row in sheet 2
  73. formula calculating itself by iteration
  74. UserForm: Only allow 2 names in a box
  75. Linking an Access Database with Excel
  76. Re: VBA Code to Copy Data from one Worksheet to Another
  77. Lookup 2 Columns Simultaneously
  78. Search/Replace String to Formula conversion
  79. Calculation using Macro ( MS Excel 2007 )
  80. Code to copy row to a column
  81. exporting excel to access macro
  82. Lookup Function (Month)
  83. Delete all rows with the data "06 - DEAD" in column H
  84. copy specific ranges based on certain values
  85. Input by many user but no deletion rights
  86. Copy 6 Worksheet Patse To Totalsheet By The Last Row
  87. Hiding blank rows on a different sheet
  88. VBA code for copy/paste logic needed
  89. Create a button to clear data in certain cells
  90. Hide Blank Rows based on 2 columns
  91. Macro Range Code based on Data Size
  92. File takes forever to open/close
  93. open & save macro
  94. sorting column
  95. Vlookup multiple same value
  96. How to automatize Salary slip preparation using EXCEL and a WORD-template?
  97. How to Combine various worksheets...
  98. Importing website data into excel
  99. Saving restrictions on cells???
  100. How to copy the first 30 rows of a sorted list?
  101. Create a "Ticker"
  102. Vlookup question
  103. Changing Spell Check language of Vba Spell Checker
  104. To Activate worksheet/tab in Macro
  105. Module not seeing functions in ThisWorkbook
  106. Reading xml datas using VBA macros
  107. Import Excel 2003 file to Access
  108. Data in Addin file
  109. Change sheet error
  110. macro that locks down cells based on a what is shown in another cell
  111. run a macro in the open workbook
  112. Listbox
  113. macro for doing something with two workbooks
  114. Macro that accesses the a web page and copies the content
  115. Error when no cells are filtered for selection
  116. Vlookup a HUGE database
  117. Count number of results in listbox on userform
  118. Hide blank rows within a range
  119. Editing columns through Userform; "Dictionary Editor"
  120. Close excel if inactive
  121. Cell formatting
  122. Sheet Name Properties
  123. Automated Replace-All Macro
  124. Subtotal Error
  125. Printing Used Range - Speedying it up
  126. Web query with login
  127. Average over different time ranges
  128. Windows Macros / Windows Automation
  129. Saving a file to a "YYYY" and "MMM" folder
  130. TextBox number / date / time formatting?
  131. VBA Code Not working?
  132. How to simulate Control (key) and Mouse (click) Selection
  133. Installing ActiveX for interactive Excel pages
  134. Date picker to update overtime spreadsheet
  135. Run macro after updating value in a Cell
  136. Range print to take account of added rows
  137. selecting the last 5 sheets excluding some pages
  138. How can I disable the mouse buttons
  139. Problem with open winword
  140. DCOUNTA Worksheet Function ?
  141. Macro to number my list in B
  142. How secure is Excel's Password Protection?
  143. Combine all worksheets into one
  144. Insert new rows and delete words
  145. run a Macro every 10 mins
  146. run a macro when a file opens
  147. Security deleting unwanted
  148. how to save different versions
  149. Workbook_SheetChange
  150. how to enable print function ?
  151. How to open Excel files and click a button ?
  152. Protecting the Macro Editor
  153. move to next column
  154. Creating a form to request a row of data
  155. MsgBox with unique ID
  156. Calling query in access from excel
  157. Is Range Exists Within Another Range
  158. Referencing cell location in formulas
  159. Run a macro on save with same file name.
  160. Tick box sort formula
  161. Math Then Combining
  162. MsgBox Selection List
  163. Updating cells with formulas automatically upon data entry
  164. Excel 2007 how to prevent asking macro at openning.
  165. Autocomplete based on a different column
  166. click into a cell to trigger an event
  167. Filter and add to textbox
  168. Test for a comment
  169. Export Report ACCESS vers Excel
  170. Macro to copy data from File A to File B
  171. Conditional formatting issue
  172. Save worksheet don't alter original
  173. Saving one of two worksheets
  174. Ucase (VBA) - If "MS" then change color
  175. Subtotalling Columns - adapting Debra's Macro
  176. Countdown Clock
  177. Lookup function
  178. Search for and extract word from a cell
  179. Hide Command Button & Rows
  180. Resetting multiple cells (to zero)
  181. Formula to Extract Date
  182. Vlookup Or Find With Textbox On Another Workbook
  183. File Size getting BIgger
  184. Macro works in VBA editor but not when run with hotkey
  185. VBA Function to calculate Mean and Standard Deviation
  186. Sorting Data
  187. Align To The Right
  188. Multiple Date Subtraction with Conditional Formating
  189. XLA Add-In Error
  190. Multiple calculation in one sheet
  191. Select Wrong Show Msg.
  192. Limited Characters in VBA dropdown list
  193. Copy values from Excel Range to VBA array.
  194. Save to FTP Server
  195. Data filtering
  196. Copy exactly what is in cell not formula bar
  197. Removing first row of excel
  198. I lost my macro button in 2007
  199. Problem Saving to a specific folder
  200. Macro - Delete Rows of a Certain Letter Case
  201. Select Range Paste Special
  202. Parse Function
  203. Deleting Column Using Macro
  204. Populate form from list
  205. Error due to different Sheet name on second run
  206. Prevent copying a READ-Only?
  207. Inputting Formulas into cells using VBA
  208. Removing text with a macro
  209. Find Last Row of Data and Use Row Number
  210. Copying CheckBoxs and Linking
  211. Vbscript to create VBA?
  212. Fastest way to fill in values on a form
  213. speed up formula
  214. transferring a macro
  215. Delete entire row
  216. reduce code which checks for changes
  217. How to splitt arabicfrench column into 2 columns arabic and french?
  218. Check boxes linked to Dynamic Pivot Table
  219. linking groups of option buttons in different worksheets
  220. Global Variable
  221. run-time error 13 type mismatch
  222. VBA Undo & Excel's built-in Undo
  223. Freeze panes within freeze panes
  224. Use information containing current date
  225. Autofill sheet 2 to items on sheet 1
  226. VBA Replace every third occurance (with one exception)
  227. looping and subtotals to AutoFilter macro
  228. Username and password
  229. Copy data to a close workbook
  230. Select alternate rows: how??
  231. Find all records that match criteria shown in list box
  232. I want to copy a row- with a macro and insert on any selected row
  233. How to place curser on blank cell
  234. Pivot table and more
  235. Format cell color on change, how to change the color in other columns as well?
  236. Organizing online bank statement
  237. How can I set a conditional range?
  238. Match 1 criteria if matches then copy the entire row plus 1 row above and below
  239. Automatic cutting and pasting
  240. How to display calendar
  241. Returning to the last-active worksheet!!!
  242. Counting number of times names show up in column?
  243. visible range..
  244. Adding Criteria To Query With 4 Tables Outer Joined
  245. run-time error 13 type mismatch (urgent)
  246. countif in the last 5 sheets
  247. creating/putting the same macro in multiple cells with independent function
  248. Merging All Spreadsheet within a Folder
  249. Transferring data to specific area based on date
  250. Problem with conditional formatting