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. Concatenate Problem
  2. Save As - triggers ListBox control
  3. auto-format
  4. Round
  5. Count duplicate combinations in 2 columns
  6. Counting
  7. Search and replace macro
  8. Pivot Table Items
  9. Simple String Parsing from Cell to Cell
  10. Capitalizing in VB of excel
  11. Looping a Solver
  12. Clear Date textbox
  13. Auto Fill Field macro
  14. saving Html without the GIF
  15. Insert EntireRow
  16. How to compare 2 lists?
  17. Worksheets("Sheet1") as variable
  18. VBA Error - Popping up message box
  19. Office2003 - Office2000 compatibility issue?
  20. Macro to consolidate data from various worksheets into one
  21. Macro compare-merge with conditions
  22. how to detect characters and add columns
  23. Writing an Excel macro to place Access fields in specific cells.
  24. Tagging Input entries with source
  25. Copying Number format from one cell to a range of cells.
  26. Sub or Function not defined
  27. date format
  28. Selecting next value in autofilter
  29. Saving as Read Only
  30. Trying to get MATCH or FIND function to work
  31. Opening Outlook Mail
  32. Referencing Another Addin
  33. Cell pattern colors
  34. Bypass the run time error if user enters a wrong value
  35. Speed Up Macro
  36. User Defined Functions
  37. Navigate command buttons
  38. Updating formula as rows change
  39. How to use the msoFileDialogOpen
  40. PivotTable lookup
  41. Convert Each column of an excel file to new text file
  42. Open combo automatically
  43. Click No Button?
  44. counter code?
  45. Commond boxes shifting to the left of the page after printing
  46. copy a column to a file
  47. Question on CheckBoxes
  48. PivotTables().CurrentPage
  49. Linking Excel to Internet explorer
  50. creating checkoff sheet
  51. Spread Sheet
  52. Macro to get info from one sheet to another
  53. Sharing excel without a server??
  54. Posting Date in Locked Cells.
  55. Selecting data w/criteria and making chart.
  56. message on opening an open file
  57. Pull query results from Access to Excel
  58. Repeat row based on text criteria
  59. merge and reset a merge based on cell content
  60. Concatenation based on range and using ALT+ENTER
  61. No more new fonts may be applied
  62. Selecting Non Blank Cells in a Column and inserting a row
  63. Macro to create a directory list (Including Zip files)
  64. Object required error in a loop
  65. Checking existance of a value before trying to select in pivot page field
  66. Formula entered from vba gives #NAME? error
  67. VBA Time format
  68. Userform TextBoxes
  69. how can I expand a column size without expanding a combobox that is placed over it?
  70. Conditional copy and pasting
  71. extract info from xml and populate to excel
  72. PivotTable In & Out
  73. Hyperlink - Message Box
  74. Error: Unable to set the Size property of the font class
  75. User Form delete duplicates
  76. Picture as Paste Link
  77. Copy and Paste via message box
  78. Search an Excel Database and display results w/ pictures.
  79. Save UserForm controls values?
  80. Help decoding code
  81. activesheets
  82. Exit event issues
  83. Variable scope problem
  84. Macro- Find then Copy Row(s)
  85. searching characters problem
  86. Getting a button name
  87. Generating Lognormal Equity Returns
  88. macro to copy a column and put it underneath another
  89. Select sheet inside or outside other select
  90. selecting a range of cells
  91. Simple find macro
  92. Automated macro for Drop Down List selection
  93. macro for cost markup
  94. Macro for more than one row?
  95. Open an Access database Import data like Microsoft Query
  96. how can create a macro with two different languages setting
  97. Paste Method error every other time I run macro
  98. Excel Trim , Clean or IsNonText function doesn't work
  99. Adding code to a userform at runtime
  100. Arranging Values in a Table
  101. Highlight max
  102. IF statement...If InputBox value equals any value within a certain named range...
  103. Locking an unlocked row when you save pr make the next row active
  104. Addressing Table cell using column header
  105. Excel as ID database and ID assigner
  106. Connecting Option Buttons, different worksheets
  107. Unbold cell in Column
  108. Cell to Cell Linking
  109. Copying Worksheets
  110. Copying ranges between sheets
  111. Paste at the end of a Range
  112. Installing Analysis Toolpak with VBA
  113. Activate Userform on Workbook Open Question
  114. Variable AutoFilter criteria
  115. Locking Cells
  116. range assignment
  117. Index and Match function
  118. Run add-in via a macro
  119. Footer Object reference
  120. check box macro
  121. Is It Possible To Validate Tick Boxes?
  122. On cell change
  123. Message Box
  124. Using Vookup to find value or Match?
  125. Inserting calendar into a sheet?
  126. Error in Workbook Open subroutine
  127. VBA control to assign work based on value entered.
  128. Update sheet2 with sheet1
  129. Send focus to textbox1
  130. Control outside applications through excel
  131. Selection or Activation of Another workbook
  132. Make folders from List
  133. a pivot table report cannot overlap another pivot table report
  134. How to get value, not formula
  135. Sending code via serial connection.
  136. Disable worksheet rename
  137. Months As Column Headings
  138. Writing a simple fill in program
  139. Text color detect from Conditional Formatting?
  140. COUNTIF multiple range / multiple criteria
  141. Application UserName
  142. code for last row in column E
  143. easy vba problem
  144. Cannot paste into one of my worksheets
  145. How do I turn off Binary Capability??
  146. Fast way to remove line borders in VBA code
  147. Loop Not Stopping
  148. VBA search box
  149. listbox with given Date
  150. Extracting column from cell address
  151. selection to comment text
  152. Code Color
  153. runtime error 1004 Options
  154. Minimising File/VBA Macro Size
  155. VBA to position a piechart once created
  156. Columns("A")
  157. Hide a Serie in a Chart ??!!??
  158. VBA Obfuscator
  159. Can I Data Validate Tick boxes???
  160. Timer in cell
  161. Delete Macro with another Macro
  162. setting a combobox list property to a named range
  163. How to make macro running faster
  164. macro to validate cells are filled before going to next row.
  165. Send email by using Macro
  166. create a folder if it does't exist? [Excel VBA Programming]
  167. Firing a macro when user moves from one row to another
  168. VBA to enable auto calculation after copying worksheet
  169. Web Query Refresh Issue
  170. Force save in directory
  171. Populate an Excel Form from a table on push button click
  172. trying to bring an object to the front
  173. update external data using a macro
  174. Calling a Subroutine (2)
  175. List of Runtime Error Codes
  176. Troubling loop errors
  177. Find Text Clear Next Row
  178. links to pdf files do not work
  179. VBA Code to select the values from a filter
  180. Sending Outlook email pop up box
  181. Times from Earliest to lateset
  182. Creating a counter to monitor changing data
  183. userform size
  184. Same Macro return different results
  185. Running a summary
  186. Activate code with value in cell
  187. Cell edit permissions depending on who is logged in
  188. Can an Auto_Close macro stop the file from closing?
  189. how to make a function run every 20 minuts
  190. Filter Question
  191. Open a file from UserForm
  192. CheckBoxes using Select Case
  193. Return to Sheet Macro
  194. Trouble calling subroutine
  195. How to skip blank cells in Function for Rank in VBA?
  196. Troubles with application.inputbox
  197. problem saving xls in java
  198. On Cell Change
  199. Sum of the cell values depending on the data from other cell
  200. Using a relative cell reference in a function
  201. Fill Area
  202. List Box question
  203. Cells concate rpoblem
  204. Project woos
  205. separate list to other excel workbook
  206. Disable Save
  207. How to fix macro that disable UNDO
  208. User Defined Object
  209. formating cells with VBA
  210. Synchronization with Word
  211. Value for Text
  212. User adding a cell value to a existing drop down List
  213. Event Macro
  214. Update Links in PowerPoint from Excel
  215. importing calender from outlook to excel
  216. Userform Arithmetic
  217. Emailing From Excel
  218. Dynamic Row Creation
  219. Reassignment of variables giving an error...
  220. Logic
  221. Auto populate data from e-mail report
  222. matching/comparison macro
  223. Macro to insert new column with the following specifications
  224. Add data from an automatic updated excel to access table
  225. VBA programming
  226. Insert Blank Rows after certain data
  227. Problem Sending embedded image via outlook 2003 from Excel 2003 vba
  228. Cell format
  229. Automation - Send Email via excel sheet and lotus notes
  230. Optimize VBA code
  231. Macro in all Excel Workbooks
  232. Pivot Table Programming Needed
  233. Links to Tick Boxes
  234. Finout max value against given date
  235. attach excel content to emails,based on criteria(very urgent)
  236. active workbook path
  237. Expand range based on count
  238. Searching for Rows and Bar Graphing
  239. Count colors with conditional formatting
  240. Application.OnTime - Automatically updating excel report
  241. Excel script
  242. unhiding worksheets by name & wildcard
  243. A loop to delete rows based on condition
  244. comparing two worksheets
  245. How to hide entire row if value is zero
  246. Fill listbox after autofilter has been applied
  247. Print Macro to Adobe Distiller
  248. create hyperlink and run with macro
  249. Selectable list box
  250. Unwanted recalculations