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. Using code to write code
  2. variable view in VBE
  3. Tag in CommandBar
  4. Help Retrieving attached file
  5. Help Retrieving attached file
  6. Setting A Range
  7. Setting A Range
  8. Macro to create pivot table from large data file
  9. Multiple Workbooks Selection.text
  10. excel form activation in macro?
  11. Column heading(A,B,C etc) and Sheet teabs at the bottom are missing!
  12. Column heading(A,B,C etc) and Sheet teabs at the bottom are missing!
  13. Add Header Row
  14. Creating a formula to compare 32 sets of data against each other?
  15. Variable for Worksheet Name & Syntax for use in formula
  16. digital signatures
  17. Dropdown List from values in a Cell Range
  18. Dropdown List from values in a Cell Range
  19. import excel to recordset in ASP
  20. Open two worksheets, then match and compare cells
  21. getformula UDF
  22. Opsummerring
  23. I'm Lost... Bin? Delineate different processes with time samples
  24. import excel to recordset in ASP
  25. Open two worksheets, then match and compare cells
  26. I'm Lost... Bin? Delineate different processes with time samples
  27. Opsummerring
  28. getformula UDF
  29. import excel to recordset in ASP
  30. Open two worksheets, then match and compare cells
  31. I'm Lost... Bin? Delineate different processes with time samples
  32. Opsummerring
  33. getformula UDF
  34. Bypass sheets.delete confimation
  35. worksheet.copy truncates at 255 characters
  36. Replace an Existing File
  37. Managing Printing
  38. Managing Printing
  39. Code stopped working
  40. Managing Printing
  41. Set a row colour when a criteria is met
  42. Calculating the end of the month
  43. "Highlight" Entire Row while entering data
  44. Macro does not function inside a list control
  45. Change case
  46. Lookup Results by selected MONTHS/YRs...
  47. Importing a file
  48. Please help correct this macro! :)
  49. Web Query TexttoColumns
  50. copy a group to a new worksheet
  51. If then statement
  52. Reference Worksheet Name variable in VBA formula
  53. Macro to find string and remove, but leave the rest of cell conten
  54. I have an msoControlEdit which I need to fix the text typed into i
  55. Iterative Correlation Test
  56. Insert cell value into a link path
  57. On the 15th Day of The Israeli Aggression : A total of 958 deaths since the beginning of the war....643002
  58. close doc and call next macro
  59. add dynamic control (checkbox)
  60. insert date timestamp to end of spreadsheet
  61. Difficult (for me) question about conditional SUM
  62. If IsNumber or IsNumeric
  63. somewhat minute technical question about selecting each cell in a range
  64. Running Excel 2000 VBA Application on Excel 2003
  65. Every other
  66. Every other
  67. Excel addin - puzzle?
  68. Every 75 rows
  69. Error when user clicks "no"
  70. Excel Autofill Method of Range Class Failed
  71. Error when user clicks "no"
  72. Every 75 rows
  73. Excel Autofill Method of Range Class Failed
  74. Charts
  75. Validation: Changing Lists
  76. If IsNumber
  77. VBA reference path goes to lower case
  78. clarification of code
  79. Determine Cell screen coordinates
  80. Best Method to Remove Data Rows
  81. Search for multiple cells with a row for matching criteria, then sum up certain column
  82. how to read dta from a web page automatically?
  83. Checkbox usage in Excel
  84. Search for multiple cells with a row for matching criteria, then sum up certain column
  85. Determine Cell screen coordinates
  86. Best Method to Remove Data Rows
  87. how to read dta from a web page automatically?
  88. Checkbox usage in Excel
  89. Recursive Code: How does it work?
  90. Repeating Menu item
  91. Can you do IsEmpty(Range)?
  92. Saving over a range
  93. VBA Timer
  94. Help!! Using IF statements for the 1st Time
  95. R1C1 to A1 inaccurate formula conversion
  96. Help - Calling Analysis Toolpak Functions from Outlook Macro
  97. Houston, We've Had a Problem
  98. Delete empty spaces at the end of text of a column?
  99. Get RGB settings
  100. The syntax for programmatically inserting a "/" in the middle of a concatenated cell
  101. search cells
  102. Re: Web Queries in Modules
  103. Microsoft Word Object
  104. Retrieving stats from LINEST
  105. Adding values to cells
  106. USER FORM COPY
  107. How to download a .txt file...?
  108. import multiple txt files in worksheet and formating
  109. Assign different
  110. formulas
  111. FileDialog(msoFileDialogFolderPicker) not using the current direct
  112. Determining last active cell in a protected worksheet
  113. Run time error '424' object required
  114. Command bar
  115. Copying rows
  116. Help with FindNext Method
  117. How can I copy the values of all selected cells to the same cells inanother Sheet
  118. Is There A Solution.......?
  119. Importing each cell in a range to a different worksheet
  120. Web Queries in Modules
  121. Using Conditions - cell colour and cell containign text
  122. Share workbook
  123. Blanks in pivot tables
  124. How to Capture insert row event in Excel using VBA
  125. How to protect a row
  126. RE: Editing a for each next loop
  127. Editing a for each next loop
  128. need help
  129. Using a custom function in a macro
  130. Find Next Methond???
  131. How to Return #N/A from a formula
  132. Extracting first two digits of a time entry!!
  133. Move a file
  134. How to increase size of image in button (msocontrolbutton) of custom toolbar of Excel 2000
  135. How do I check the number of rows selected
  136. save and delete a file when in it with code
  137. Column transfer
  138. Quick question about moving around a worksheet using vba in a macr
  139. userform label creation
  140. Userform Copy related...
  141. Find text within a string
  142. Move data to new sheet depending on criteria
  143. Is It possible to get Lisbox1 windowlong ?
  144. Workbook.Path
  145. Using a macro to edit part of a cell
  146. Excel 2000 VBA Application on Excel 2003
  147. SaveAs function and Send mail in VBA
  148. Autorun macros on opening
  149. Custom Views
  150. How do I code VBA to hit button on a different worksheet?
  151. HELP!!! DOGS IN CHINA
  152. HELP!!! DOGS IN CHINA
  153. Question about using FIND in macros
  154. Modular Arithmetic
  155. Problem with cell references in my macro
  156. Change Defined Name Constant String
  157. Help with a Type Error
  158. Calendar Control, Weekly
  159. Conditional formatting of adjacent cells based on text in cell
  160. Thanks to all for the help
  161. Passing indexed array value to VBA function
  162. Help: Dynamic Total Updates?
  163. Reference worksheet by partial name ?? wildcard
  164. macros?
  165. Selection to Array and Array to Sheet
  166. Public variable not recognized in event
  167. Using Code names in formulas
  168. Macro creating second chart
  169. What key is being pressed when running a macro?
  170. Import Module
  171. RC format formulas
  172. Combobox - can't get click event to run for first item in the list
  173. different ways to copy a range?
  174. Open an Excel Document using VB
  175. put cells based on condition in sheet2
  176. write out formatted text files
  177. copying a range using syntax 2
  178. SendKeys Help
  179. Remove Macros before send? & Runtime error if choosing not to overwrite file?
  180. On the 15th Day of The Israeli Aggression : A total of 958 deaths since the beginning of the war....477820
  181. save as csv cell format
  182. Excel Image Background
  183. usernames and passwords
  184. Save As causes Crash!
  185. Excel 2003 cell limit
  186. Running Total in Pivot Chart Not Displaying Individual Value
  187. RE: "if" question
  188. a challenge for a VBA guru
  189. Problem setting combobox
  190. "if" question
  191. Named Range
  192. Programatically access Excel 2003 spreadsheet
  193. Military time caculation help needed
  194. Run time Error 6
  195. Help with Error Handlers!!!
  196. How do I VBA....to go through a recordset and eliminate duplicate
  197. How to track formatting changes
  198. Update Web Query Parameter with a Macro
  199. sum a column based on multiple other columns being true
  200. Combining data from two columns
  201. Calculating Friday Date
  202. Testing an object varible for Nothing
  203. Remove Reference from VBA Projects
  204. selecting row from active cell selected
  205. Excel & Candlestick Graphs?
  206. User switching between sheets while data is being logged
  207. Distributed Excel Application
  208. Running GIF in userform
  209. Running GIF in userform
  210. stupid round question
  211. Counting in a variable range
  212. Excel Formula for "Litres per 100 Km"
  213. Memory leak in names collection?
  214. Excel 2000 to 2003, Resources for Compatability?
  215. Excel Formula for "Litres per 100 Km"
  216. Excel 2000 to 2003, Resources for Compatability?
  217. Counting in a variable range
  218. Memory leak in names collection?
  219. HELP!!!! DOGS IN CHINA
  220. HELP!!!! DOGS IN CHINA
  221. loop to find cells with specified value
  222. Cell Referencing Error.
  223. Opening Templates
  224. How do I stop Excel from resizng columns in VB6
  225. more efficient VBA?
  226. Digital Signature in Workbook
  227. how to increase size of button's image of custom toolbar of Excel
  228. Split up word in cell
  229. Label Colour Fading
  230. Sorting
  231. Paste clipboard to a comment
  232. Splitting Text Out of a Cell
  233. Replace() to "Find whole words only" ...
  234. ComboBox List Formatting Issues in European Regions
  235. unprotecting sheets in another workbook (syntax problem?)
  236. Find Date form list
  237. How do I remove macro at excel startup?
  238. Personal.xls vs Add-in
  239. MACRO, help for making
  240. What is this code doing?
  241. find mid value of string data in data with integers
  242. copy cell based on condition where row numbers are not the same.
  243. Error 1004 Method 'Range' of object '_Global' failed
  244. Auto Correct Problem
  245. Loop, If or another thing to use???
  246. combobox auto fill in unicode...
  247. A macro to update links
  248. Range within Formula
  249. Find text in specific cell??
  250. importing entire workbooks