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. Limit to field size with .CopyFromRecordset
  2. VLookUP ARRAY , how can I make it not relative in macro?
  3. is there worksheet Int function to round decimals up instead of do
  4. Match function and displaying results
  5. write WorkBook_close event dynamically
  6. # of Days in a Year
  7. Take Action Based Upon # of Rows in Another Worksheet
  8. UserForm Data to Worksheet
  9. Exact lookup formulas, VB Instead?
  10. Go To Next Worksheet in Loop
  11. Subtotal multiple columns
  12. formula help
  13. how to suppress "update links" message for workbook with no links?
  14. Comboboxes on userforms
  15. Deleteing a portion of a cell.
  16. Date to refresh in chart title
  17. Some ideas
  18. Reset workbook counter to "0"
  19. Copying Regions with Filters/Hidden Columns
  20. AutoFill Using a macro
  21. Confused - Range and Cells
  22. Passing a list to an array
  23. how might I tell a user they did not enable macros for excel?
  24. Passing a list to an array
  25. conditional statements
  26. Reply to outlook email from excel script
  27. MsgBox Interactive
  28. permutation of values in 2 dimensional array
  29. MultiPage change CRASH!
  30. Interop - "Unable to set the Color property of the Interior class"
  31. Keeping 0 at beginning
  32. Count different values in a column
  33. Need one miracle
  34. Combo Box / VLOOKUP
  35. Reviewing a list of defined named ranges
  36. Copy data in named ranges to a newer version of the same template to identical ranges
  37. VBA for Cell locked please help
  38. replacing defined names for ranges
  39. Help with VBA...
  40. Displaying all Named Ranges in workbook
  41. Convert Binary to Hex
  42. conditional formating
  43. Userform with spreadsheet control will not load
  44. How do I test if the weekday is between Monday and Friday ?
  45. activate last worksheet in a different workbook
  46. Separating text and dates.
  47. Macro for comparing Hotel Prices
  48. Search a string
  49. Modifying code to Consolidate only 1 column..
  50. Print ranges based on cell value
  51. How do i count date cells without duplicate values in excel?
  52. Conference pictures
  53. Creating a Macro for refreshing data in a columns
  54. VB Code to Send Workbook to a FTP
  55. Creating a Macro for refreshing data in a columns
  56. Conditional inserting content in new rows in other file/sheets
  57. Conditional Minimum value
  58. Sorting list
  59. Macro to sort values in list without 0's (zeros)
  60. vbOKCancel box to close
  61. search for duplicates
  62. Building an application on top of Excel
  63. "On Error" help required
  64. Timing/loading bar
  65. About Excel Version
  66. Value on worksheet with fullstop either side
  67. Get all files from folder
  68. Provide a check in VBA for backward compatibility of commands
  69. extracting data from excel
  70. How do I get User Form to run at start up?
  71. How do I print hidden pages?
  72. Save as .pdf
  73. Intersect Method
  74. Reporting several Bugs for Excel 2007 Beta 2
  75. Commands for cursor moving right, left, up, down.
  76. NumberFormat for date axis is not working
  77. Unvisible checkbox
  78. How to add data to separate worksheets?
  79. Need help with an excel formula
  80. where to place undo-function in vsto-projects?
  81. Copy worksheet name into cell A1?
  82. Array Formula cell via Excel VBA
  83. Line numbers in VBE
  84. Find a cell and then insert a formula into adjacent cell
  85. I am getting Unable to record
  86. Reset Checkboxes from Control Tool Box
  87. Command button auto select after pressing Enter
  88. Excel
  89. tabstrip name format
  90. Check User
  91. Chart Hide/Unhide Series
  92. Visual Basic - active macro on cell click
  93. Need someone's help with this issue...much apprecaited!!
  94. How to find a particular cell using macro?
  95. Button to print non-active page - How?
  96. AutoCorrecting in VBE ??
  97. Referencing Diff Sheet in Formula in VBA
  98. Label = whole number - How do I set this?
  99. Formulas or VBA?
  100. Controlling scroll bars in file dialog
  101. Vlookup/address question
  102. Text box caption=Cell Value (without command click)
  103. Locating Matches & Highlighting Background
  104. Manpower Schedule
  105. insert rows in multi sheets
  106. Lock single Module ONLY in workbook; without locking VBA project?
  107. Help! I can't get a spreadsheet to open
  108. How to use send keys to unprotect VBA project
  109. macro Cell designation
  110. Clearing row colour & row data
  111. Identify non-alphanumeric characters within a cell in Excel
  112. Worksheet_SelectionChange Question
  113. need help on delimited
  114. Detect Cell Changes
  115. Need help from Excel and SAP expert!
  116. Formula Problem Summing Data in Cells on Previous Worksheets
  117. dynamic web queries with vba
  118. FullName vs FullNameURLEncoded
  119. Range.Text/Value returning the number 3?
  120. GetOpenFilename FileFilter
  121. Recording highest value dynamic cells
  122. VB.Net - retrieve actual formula string
  123. Creating and Naming a Folder and populating it with files
  124. Creating and Naming a Folder and populating it with files
  125. Copy Data
  126. Macro =sum function not working correctly
  127. Highlight text (interior color)
  128. Userform and Goal Seek
  129. Need workbook w/ VBA to open in new & separate application window
  130. Such a thing as CurrentCell..? ThisCell?
  131. Adding shape-type textbox into excel chart sheet
  132. Printing Multiple Sheets
  133. Printing Multiple Sheets
  134. Accessing Image Pixel Data
  135. Polulating Combobox's
  136. Stock Quotes from web
  137. Remove Holidays as DateSerial using Case
  138. Excel and launching userforms
  139. Excel functions and programming
  140. do i need to macro this function? seems too simple
  141. How do I create a excel Template to enter data into same workbook
  142. How to Use Chip Pearson's Text Import Code
  143. Recovering the ribbon in Excel 2007 after an error
  144. how to use if command with time in function?
  145. need help for a golf spread sheet
  146. Need help with loop code
  147. how do you create a bell chart for sigma using excell?
  148. Referencing data from another workbook
  149. Initializing UserForm which uses MultiPage controls, part 2
  150. "Renaming Form Buttons From Macro"
  151. Convert Time Decimal to standard time.
  152. Conditional Formatting using cell from another worksheet
  153. My 1st IF-THEN-ELSE Procedure
  154. Using Built in Functions in VB Code
  155. Delete Rows With Specific Text
  156. More RGB Woes
  157. Command reference manual(s)
  158. run macro upon clicking a cell?
  159. Help with VLOOKUP / VBA code, please...
  160. what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
  161. Autodate worksheet problem
  162. Lists in excel
  163. How to paste HTML code as text into a worksheet?
  164. AutoFill Macro
  165. ActiveCell.Row in Range().Select?
  166. couple userform questions
  167. Sum after sorting
  168. If event When a specific cell changes
  169. How to embed a macro in a flat file?
  170. Info from User Form to Data sheet and back
  171. Find text in a cell and select whole row question
  172. worksheet linkage
  173. sum function
  174. Need help setting the worksheet header/Footer margins based on string height?
  175. Need Help with printing multiple sheets Please
  176. fonts names in loops
  177. Upload Workbook to FTP ???
  178. Setting Funtion Value to Cell
  179. How to avoid volatile hyperlinks?
  180. How to arrange that macros are from THIS w/book?
  181. On Error Resume Next
  182. The most powerful computer security tool
  183. Worksheet place in workbook
  184. prop. scale images - have code, just need slight mod
  185. Listindex problems in multicolumn listbox
  186. Parsing a name
  187. VLookup Error
  188. Custom Quoting
  189. Error handling in VBA 6.3 in Excel 2002
  190. pivotable drill down
  191. command to do "nothing" in If/Then statement? #2
  192. command to do "nothing" in If/Then statement?
  193. Templates and passing functions
  194. Macro that AutoFilters based on Cell value
  195. Setting a value is slow
  196. Clear color but not pattern?
  197. Pasting from Excel to Powerpoint
  198. I need to Round Cells up to next .99$
  199. Delete row data and cell colour
  200. Combine date and time
  201. Add/Delete rows based on count
  202. Macro to insert object into spreadsheet ??
  203. Sumproduct Error
  204. Worksheet_Change problem
  205. delete row of text with 3 macros & [placeholder]
  206. Macro that adds records
  207. How can I duplicate conditional formatting
  208. Excel - User Defined Function Error: This function takes no argume
  209. Vlookup
  210. Problem placing embedded charts
  211. CORRECT SYNTAX FOR RUN...
  212. CORRECT SYNTAX FOR RUN...
  213. Embedded Excel Object - Containers Path and Name
  214. Recording date Excel file is attached to e-mail?
  215. count of rows
  216. PivotCache
  217. add prefix to filename - macro to loop down column
  218. select one value from drop-down and return multiple corresponding values
  219. select one value from drop-down and return multiple corresponding values
  220. select one value from drop-down and return multiple corresponding values
  221. Problem with discussion group
  222. Excel spreadsheeting
  223. Lost Basic Excel & Word
  224. Challenge of the day: linking VBA code to combo box selections
  225. Macro to test characters with block of cells and change font
  226. selecting data in combo box
  227. selecting data in combo box
  228. If column B not empty, value in column A = L
  229. Drawing Program Collaboration
  230. Finding window handle of data validation listbox
  231. DEFINED NAMES AND FORMULAS
  232. Linked Workbooks
  233. Make field Fixed lenght
  234. Sumproduct Problem???
  235. Incorrect usage of VBA WSfunction
  236. overlapping picture problem
  237. Open all files in subfolders
  238. NEED HELP - For run time error '1004'
  239. inheritance
  240. VBScript MS Excel Problem
  241. NEED HELP - For run time error '1004'
  242. Excel Macro
  243. Changing the value of a protected cell
  244. copying name box to another sheet
  245. Download with Active X
  246. SaveCopyAs - Timed Capture
  247. Formula not evaluating immediately
  248. Post File Size In Cell
  249. "Can't enter break mode at this time"
  250. Can this code be modified to delete rows?