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. different excel version, same add-in?
  2. Subscript out of range error
  3. Disable columns
  4. events for tabs in a userform?
  5. Comparing 2 cells and copying rows to new worksheet
  6. Set a value in a procedure
  7. Importing data into Excel from Access
  8. Need help in my VBA code
  9. Sheet Tab Color
  10. Finding Empty Rows
  11. How to return the name of the sheet from which the function is called
  12. Do While
  13. VBA line to share a workbook
  14. Search Routine
  15. Detecting duplicate entries
  16. Type mismatch on if statement
  17. If Condition Then find and delete
  18. Looping help please
  19. Hyperlink to a workbook Add-In?
  20. Adding a data in a cell from a drop list
  21. Protecting a sheet with a password using VBA code
  22. Automate creation of monthly invoices
  23. labeling worksheets
  24. Custom Function not calculating properly
  25. Cell not visible because of the autofilter
  26. Sheet Tab Color
  27. VBA Macro help needed
  28. .Text to .Value
  29. Help Required
  30. Which toolbar Button was clicked?
  31. Email question re: Ron De Bruin sending sheet as html
  32. Get value and add next cell
  33. this last Saturday's date
  34. Time in and time out
  35. Delete column when workbook opens
  36. Selecting a graph immediately before a sheet
  37. Help with cell reference
  38. Auto Time on Click
  39. userform as startup object.
  40. keep row if cell value is 7 digits and all numbers
  41. Add range in a loop
  42. Conditional Format - range
  43. Help! Vba Copy Cell To Different Worksheet.
  44. Excel Short Cut Keys
  45. Row & Column Auto Hide Through Macro
  46. How to restrict scroll area using vb?
  47. Why is Workbook.Add causing this issue?
  48. excel to play sound file
  49. Error 91 When Closing
  50. Help: Logic for reading/writing cell values based on dual combobox selections
  51. RE: Time Rounding Up and Adding
  52. Set Value For All Macros
  53. Hiding Rows Based on Results in Other Rows
  54. Sort using a variable for range
  55. Question on where should I look.
  56. Validation with ChangeEvent?
  57. Passing Working Storage between Excel Events
  58. determine active or selected worksheet
  59. Converting Crosstab into Tabular Format
  60. Match & Use Figures
  61. Providing "descriptions" for VBA User Function Arguments
  62. Extracting 28 from a string
  63. vba help for datavalidation
  64. Remove ByVal Target As Excel.Range
  65. Putting powers on to a Matrix?
  66. summing 1 to 'n' values in a worksheet
  67. VB Code
  68. Conditional formatting
  69. Pop Up Window when text entered into cell
  70. Excel Version
  71. VBA help for excel
  72. Get external data from secured access database.. Help !
  73. Type Mismatch I can't figure out!! (VBA)
  74. VBA code - color format routine
  75. Inserting Pictures in Excel, need auto adjustment on size
  76. Macro Help
  77. disable exe file
  78. Macro/VB help with color of cells
  79. Importing Data
  80. Cannot assign a hyperlink to a button
  81. ActiveCell =last cell clicked
  82. Creating a conditional table?
  83. Macro help please
  84. Running Macro's from "IF" statements
  85. Put row height in column F of a changed row's height
  86. Personal.xls Deletion
  87. VBA Guidance needed
  88. Translating letters from english to russian
  89. ActiveSheet
  90. Macros and custom toolbars
  91. Totaling Columns
  92. Product List
  93. Macros
  94. Popup window that accepts data and calculates.
  95. Fun with Filters
  96. Running Scheduled Tasks Macros While Cpu Is "logged Off" From Network
  97. Compare two Formulas
  98. Simple textbox question
  99. Different page orientation on one sheet
  100. ShowDetail in pivot table
  101. Custom Web Query
  102. Editing User Defined Lists - Beginner
  103. VB xml question
  104. VB Coding Help
  105. Find Unique row and sum and other questions
  106. Missing rows
  107. Outlook object send item
  108. Using the Workday function
  109. Saving a Sheet as Text file
  110. UserForm: load path of jpg in cell
  111. Help with a date code
  112. Reading specific characters from closed files
  113. Clear a check box
  114. Automated Excel Reports
  115. Playing With Numbers
  116. Call function to fill Listbox
  117. Updating Pivot Tables
  118. Paste Special Graph from another worksheet
  119. Adding Sheet name to Footer
  120. Don't understand the off-set
  121. using VB to link formats
  122. auto input on selection
  123. comparing data and producing the result on another sheet
  124. Filtering and drop down lists!
  125. Collation of data from multiple worksheets
  126. group rows
  127. How Do I....
  128. Dropping Numerical Data from MS Word .rtf File into .xlS
  129. Initialise List Box
  130. Order open/close workbook conflict?
  131. how to determine if a cell has a name?
  132. Select A1 cell?
  133. Automatically Close Workbook If Another Workbook Is Opened
  134. What's wrong with my code please
  135. Please Help
  136. Formatting with Ranges
  137. Need help on Worksheet_Change & User Forms
  138. Help on the Option Button Please
  139. Option button
  140. Looping through sheets
  141. Help
  142. Varying a value
  143. display information - macro help
  144. possible to delay comments until user form receives input?
  145. Find value and copy row into new sheet
  146. Fiscal Date Function-PROBLEM
  147. Populating an array from a range, to populate a combobox.
  148. Problem with Closing an open workbook with vba.
  149. User Defined Functions
  150. Format Dates
  151. Thanks Carim but.......
  152. Problem with apostrophe in a string
  153. Beginner needs HELP with .Text
  154. Marco Loop Question
  155. Adding Vat
  156. Selecting a variable range
  157. HELP:Last Day of Month reverts to First Day of Month
  158. HELP:Last Day of Month reverts to First Day of Month
  159. Pulling data off of the web.
  160. Advanced table selection switchboard
  161. Cna't switch open workbooks
  162. Need some help please
  163. Create a new Sheet if it doesn't exist?
  164. Vlookup Questing
  165. Randomly Pair Names in a list
  166. football stats
  167. Here's one for the experts
  168. Excel VBA Help
  169. type matching
  170. E-mail workbook problem
  171. Finding Users
  172. Beginner needs help with UserForms
  173. Date and Currency Format
  174. How to display a balloon and place some text in it
  175. search text in another application
  176. Editing Command bars
  177. macro problem
  178. Adding auto complete to a drop down menu.
  179. Multiple Column Sort via Macro
  180. Find maximum in a range with vba
  181. Deleting offsetting records
  182. Help me Modify this Insert Blank rows & Formula
  183. Checking Range
  184. Quick MsgBox Question
  185. Why can't a make this formula in a textbox?
  186. ¿How could i search a string from Book 1 into Book2?
  187. Assigning to consecutive variables
  188. Issue clearing previous selection
  189. VB Coding. Who's got the Knowledge?
  190. Default values in textbox
  191. Looping through crosstab worksheet
  192. Multiple Dynamic Menus
  193. Compare dates with today()...
  194. Very basic (not the language) Macro help
  195. myRng as String and use myRng As Range?
  196. How do I create a macro to run queries with worksheet data
  197. refresh
  198. custom toolbar
  199. Advanced Invisible Button
  200. job sheet task
  201. Creating questionnaire - hiding questions
  202. Kill Worksheet!
  203. Some Advice Please....My head hurts
  204. HELP: Using a macro to update links
  205. Printing Worksheet Multiple Times
  206. DateSeriial in Sub Routines
  207. To look for a specific value in one doc. then insert in Excel
  208. filtering in protected sheet
  209. Different footers on subsequent pages
  210. Print to a word doc
  211. error 1004, method of class/object failed
  212. Insert value into mp3 tag
  213. find a particular character in a cell
  214. Vlookup Based on Cell Date
  215. Changing Digits
  216. Using VBA to move screen selection
  217. Removing a Digit using a macro
  218. Copy-paste question
  219. Code to delete code
  220. MAcro color changer
  221. Removing command buttons using code
  222. Saving and Closing Workbook
  223. how to merge data from one excel into another excel
  224. Entering the date in a userform
  225. Newbie... Macro - Importing multiple csv files to excel
  226. Paste Special with sheet macro problem
  227. Copy a formula to cells in column A which don't have an empty cell in column B
  228. Looping two criteria - Beginner help
  229. Help with the use of 'Range' in Macro
  230. PASS down parameter from DOS to Excel
  231. Unique Identifer
  232. conditional formating
  233. read date and highlight if a month passed
  234. vlookup formula
  235. Stripping out repeated entries from a column
  236. Reassiging yellow color to cells
  237. Format a number in VBA : 1 --> 001
  238. Macro help needed
  239. Macros: Explaination on Logic for this Code?
  240. Simple (I think) problem
  241. Hide row based upon cell value
  242. Highlighting a cell when I enter data
  243. Code problem
  244. Unwanted Menu Bar
  245. referencing a workbook
  246. Formating with a macro
  247. Making this code work
  248. Need a macro to search and remake any list
  249. BRILLIANT EXCEL ADD-IN IDEA - Requires Calling a DLL Function Written In C
  250. Format Currency in VBA