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. Sent e-mails via vba excel
  2. Selecting All Buttons
  3. Generate Graph Automatically
  4. Looking for UserForm textbox with scrolling
  5. Increase vertical spacing in a listbox
  6. How to group several customized addins
  7. Looping Code
  8. How to span results across worksheets
  9. Auto Invoice number copied sheet
  10. Search/Lookup Code?
  11. Auto start for a macro
  12. Excel VBA Problem
  13. Passing Old Value's to comment
  14. customer data entry system
  15. Macro between Word and Excel
  16. Find and copy data
  17. Sorting like MS Access
  18. Change shape color on mouseover
  19. SPC charts macro
  20. array as lookup values
  21. macro to delete all text after colons
  22. Adding data to next vacant cell
  23. Insertrow macro
  24. Calling Stored Procedure
  25. Looping through textboxs
  26. auto tracker function and sending of personalised email from outlook 2000(Urgently)
  27. Excel - Query - Automatic EMails
  28. Format Result Of Date Diff To 2 Decimal Places
  29. Selecting column of the active cell
  30. Complex nested array formula problem and challenge
  31. Vba to run macro in another book
  32. SpreadSheet Control - Import using Code
  33. Macro/Security/Trust Access...
  34. format now() to date
  35. error in vba (DATE)
  36. Link Pivot Item Question
  37. Move one record in a range to the top
  38. Count Macro
  39. Locking cells using a macro
  40. 2 WBs, forms in one, sheets in the other
  41. check boxes and if formulas
  42. On _Initialize ?
  43. Returning user to the starting cell
  44. Keep first digit in cell (if "45", return "4")
  45. Run Macro on Multiple Workbooks (.csv) Files at Once
  46. Why are IFs not working?
  47. Delete rows on conditional basis
  48. deleting cell contents in multi ranges
  49. Number stored as text
  50. Maximum UBound Array Limit
  51. Sort direction selection
  52. If Statement to If Statement
  53. Excel Automated Mailmerge with an Embedded OLE Word Object
  54. Using VS.NET 2005 with Excel 2007
  55. True If contains
  56. Assistance with macro coding
  57. if an error occures
  58. Sort Data Problem
  59. Retrieve access data into excel
  60. Play Wave Error...
  61. Finding individual figures that make up a total.
  62. excel open in IE commandbar problem
  63. can I add a submit button?
  64. Printing Macro
  65. BeforeDoubleClick bug
  66. nested ifs not executing
  67. if exists code
  68. Generating Data into form layout
  69. Convert two-byte numbers to one-byte?
  70. Opening Web Pages
  71. auto no to saving
  72. Macros in Default Workbook
  73. Creating a Search option and more.
  74. Printing Word Documents based on .xls name list
  75. Insert Table into Word From Excel Vba
  76. Using VBA to convert text to proper case
  77. Creating a folder from VBA - Easy one for you!
  78. deleting code
  79. Range Name for Private
  80. Stopping After 1st If
  81. Dumping Values onto Col H
  82. saving excel in ascii?
  83. Enquiry toolbar
  84. Bloomberg/Excel - Principal/Interest
  85. Help; i need to do invoice quantity...
  86. worksheetfunction vlookup
  87. XML to Excel
  88. Using Cell.Vaule in Formula
  89. Highlight control in Excel form
  90. copying cells to a new workbook
  91. Excel Protection Message Overriding.
  92. Problem related to List box
  93. Login to Outlook 2003 with VBA
  94. Calling DLL from VBA
  95. summation
  96. VBA Code to read the structure & data of an excel sheet having merged rows & columns
  97. VBA warning for misplaced workbook
  98. How to copy the content of a webpage ?
  99. adding to cells when other cell = a multiple of a number
  100. Error with copy/paste
  101. Date Range Question
  102. Passing Variables out of Subroutines
  103. multiplication
  104. Stopping Excel From Opening
  105. Mutliplying text and number values Macro with mutliple conditions
  106. if and statement not getting the right results
  107. vba - copy entire row based on cell value
  108. Open New Workbook with 0 Sheets
  109. vba range
  110. Array/Loop to Delete Rows?
  111. "Move selection after enter"
  112. Use of formula in VB script
  113. Require data entry
  114. combine url and address column into linked addresses
  115. To create a form to print
  116. Save spreadsheet with VBA code
  117. Coding CountIf Statements
  118. Macro writing a protected worksheet
  119. Injecting Range into Word
  120. VBA - copying existing file and renaming with date
  121. Closing User Form
  122. If And Not then stmt trouble
  123. stopping copying and emailing of an Excel file
  124. Need to Select/Format/Sum 2 moving Columns
  125. Copying parts of a large table into a new Sheet
  126. InputBox
  127. User form
  128. Macro
  129. MsgBox
  130. Dates macro
  131. saving auto replace
  132. Assign a SQL Query result to a VB Variable
  133. Dialogs
  134. Clearing cell range when a particular cell changes
  135. formula writen as vba
  136. Find drive letter
  137. Referencing a form in an .XLA
  138. Select active cell and return value
  139. Create a new folder of .jpg files from Excel
  140. Sorting data through VBA (Quick one!)
  141. comparing mutple fields on a row with rows in another worksheet
  142. Automatic updation of workbook without any manual intervention
  143. deleting rows using vba, based on values in a cell
  144. copy formula
  145. problem with defining name in cells
  146. Clear content of cell if has some character.
  147. protecting all sheets at once
  148. checking for empty values and using offset
  149. summery excel book
  150. Clear contents of cells
  151. Selecting Columns
  152. Using formulas in VB with variables passed from Excel cells
  153. Copying a range
  154. Rearrange the worksheets in two workbooks
  155. Change Network
  156. sheet tabs in alphabetical order
  157. Selecting random cells using certain criteria
  158. Sheets Tab
  159. Delete Duplicate Ranges in Excel
  160. Copy horizontal row to vertical column
  161. for loop
  162. If statement
  163. Listbox - 1 item have a color background
  164. a simple macro question
  165. POP up but no VBA
  166. marco / module question...
  167. macro copy
  168. VB codes for delete command button
  169. Counts Cells - VBA
  170. AutoFilter Criteria in VBA
  171. Cosolidate multiples sheets
  172. Emailing
  173. Formating Form Text Boxes
  174. Import information for specific workbook if other workbooks are open also
  175. Object Array / Loop
  176. Find and Replace values from multiple lookup values
  177. Input parameters to an excel Application
  178. Getting data from "Name"
  179. saving as the date
  180. Displaying and Un-Displaying Objects Using VBA..
  181. Need Help
  182. Duplicate/Conslidate Problem
  183. Shorten Code?
  184. Communication problem Excel Macro / Oracle
  185. Stop duplicate entries
  186. Copy cells from other worksheets without opening them
  187. code for cell referencing in VBA
  188. Lists of Objects?
  189. Code snipped
  190. Macros/Programs to Format of Cell(s)
  191. Adjust row height based on cell value
  192. My code is running pretty slow with the loop that i have
  193. Time Saving Techniques?
  194. Import static data to excel
  195. VBA Issue / Setting Pivot Field Page Default Item
  196. Text box format control
  197. Textbox number format
  198. How to Copy rows which match criteria into a new workbook and format it
  199. Move Data
  200. Excel data validation and cell dependency
  201. Close files without being prompted
  202. Cell Colors
  203. Colour in a range of cells if another cell changes condition
  204. Combobox Error Message
  205. Macro to transfer data between sheets...
  206. Array formula in macros
  207. add new entry
  208. Copy Range to last worksheet
  209. VBA: cell swapping & cell referencing
  210. condensing vba code
  211. Get cell name? id?
  212. Use a calendar control with multiple destinations
  213. Deleting rows
  214. vba or formula
  215. Hiding duplicate data
  216. Paste Data from one WS to another
  217. Convert Decimal to Percentage
  218. Importing data from a specific workbook
  219. Controlling Outlook from Excel
  220. sheet deletion
  221. Using VBA to print and save as a range of cells
  222. UK/US Date problems with macro
  223. How to create a new sheet using VBA?
  224. pivot table connection to odbc
  225. Userform spacing on screen
  226. Select the next empty cell
  227. assign values to an array
  228. How do you select a range of cells on another worksheet using the Cells property?
  229. Problem with names/ranges in VBA
  230. Sumproduct
  231. On click, copy the corresponding row to a new dynamically created workbook
  232. Linking Colour formats using a function
  233. syntax question
  234. Read system variable
  235. Excel to text, compare, text to excel
  236. Writing results to a new spreadsheet
  237. Entering a formula from macro...
  238. VBA Error 2029
  239. Fileopen Logic
  240. 2 different amounts in 1 cell
  241. Shorten Code and Cell Select Issue
  242. Macro to prompt for information before inserting column
  243. Formula to Total Spend depending on Department
  244. Parsing text file to Excel (VBA)
  245. Command Button to select from Autofilter
  246. Remove closed VBProjects
  247. Macros
  248. VLookup in Dynamic Range
  249. absolute cell referencing in VBA code
  250. 2 character codes