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. multiple sheets + transpose + date
  2. Formatting display properties on all sheets
  3. List Range names in VBA
  4. Remove character from the entire row
  5. user defined function using Array
  6. Type Mismatch Errors...
  7. Tab Order
  8. VBA - charting problems
  9. Default Cell Value
  10. Running Excel Macro with Menu or Toolbar
  11. Search folder for all excel files
  12. Refresh external data by command line?
  13. Unprotecting macros
  14. Dates function/macro
  15. Transfering information into diff. layouts
  16. Userform closing error
  17. How to programme a workbook to delete iteself
  18. Sending HTTP request with parameter.
  19. Formating URL In Excel
  20. Hide Combo Box
  21. writing excel VBA Query for fetching data from Access
  22. Search date from one spreadsheet to another
  23. merging worksheets in a folder
  24. Product list to week columns
  25. Row Grouping Macro
  26. IF/MAX/MIN statements
  27. how to do summation of checked boxes?
  28. Print Worksheet From Custom Button Only
  29. Reference another sheet?
  30. speed up my code?
  31. Save as In sequence
  32. saving excel files by cell data automatically
  33. Shared workbooks and protect/unprotect problem
  34. Move rows according to colour
  35. Enable Macros After External Data Import
  36. Macro that delette area in certain conditions
  37. Automatic Change in Code
  38. If-Else just stops
  39. =IF() replaced by VBA code
  40. extend conditional format
  41. combo box
  42. Looping through TextBoxes
  43. microcontroler code
  44. Calendar Autodater
  45. Compiler Error
  46. DDE (dynamic data exchange) and automatic charting
  47. When the query updates I need to save
  48. Using Add-In Functions In the Insert Function Dialog
  49. VBA: How to handle save changes prompt?
  50. Loop & Offset assistance required
  51. Looping to check several cells for values
  52. Using a variable in a formula
  53. How to save contents of a cell into a string
  54. save as ("X").xls
  55. How to get hall of a cell????????
  56. Scrollbars within cells?
  57. Resizing graph in Word using VBA...
  58. Deleting rows based on True/False Criteria
  59. Update label caption upon selecting Listbox item
  60. vlookup path not working in UDF (User Defined Function)
  61. Printing selections
  62. Running Import Webpage in Background
  63. Changing font size in a range based on cell value
  64. Automatically producint 'n' sheets from two excel wkbks
  65. Excel template behavior in IE
  66. Undefined in Context error?
  67. Applying Module to multiple sheets
  68. Select last "n" columns
  69. Hiding 1 Row also hides a different row
  70. Incremental cell selection in a 'for loop'
  71. auto filter
  72. Assign Macro to Button control
  73. Worksheet_Change function and circular reference error message
  74. required to find the time!!!
  75. Determine filesize of external file
  76. Date wise calculation
  77. Message Box
  78. Is there a better way
  79. Setting ComboBox.RowSource via Named Range
  80. More than one visual basic code
  81. Loop down a column to its last value
  82. Import big text file into multiple sheets
  83. User-defined function is preventing Worksheet_Change
  84. automatic update from excel sheets into a single sheet
  85. Insert Tab and format as Macro
  86. Writing a Function
  87. Automation Error when trying to export
  88. Check for duplicates
  89. Conditional Formatting
  90. Why does it not print the 4th week?
  91. Using a variable in a range
  92. Percent increase calculations...
  93. DB import for different users
  94. Input box appears with text entered...
  95. Insert Filepaths to Cells
  96. Loop all items of a pivots currentpage
  97. autofill+addrows+lookup
  98. What Am I doing wrong here?
  99. Create a macro that goes in internet Explorer
  100. Shared workbooks + Forms
  101. return textbox value to another macro
  102. Hello
  103. Password!!!
  104. compile error
  105. Increments of 0.5
  106. Open New File & Copy To Existing File
  107. how to change the text of the button, accordingly to a cell that reads 'true'/'false'
  108. how to link a "dot" checkbox to a particular column of another spreadsheet
  109. Default Date Format
  110. Loop with a loop? or something else..
  111. Non-Contiguous rows - reselecting originals
  112. Does any1 know of a Macro the add Thick border when a different date is found in cell
  113. Substring based on position in string
  114. subscript text
  115. Stopping a spinner when it's reached end of results
  116. Function or Sub Not Defined Error in Personal.xls Macro
  117. Set Me.Picture on UserForm_Initialize
  118. AD Record Set Value manipulation..
  119. Adding Row Values depending on Corresponding Rows
  120. Opening files with a filebrowser
  121. Getting username for last update on closed xl wb
  122. Data and number manipulation
  123. Flaging identical data in 3, 5 and 20 consecutive cells in a column
  124. ClearContents
  125. Duplicate Save
  126. Loop Question
  127. Button macros
  128. Macro to work out max min and average
  129. is it possible to overload a "Property Get/Set/Let" procedure in VBA?
  130. Proceed Data and save in different files
  131. Passing variables to Range function?
  132. Error in formating cells / range
  133. How to copy and paste using macro
  134. average rolling periods
  135. mutual exclusive write to Excel file
  136. Vlookup only returns the first value
  137. setting scroll in VBA Editor
  138. Deleting rows with any of 6 different values
  139. Email and Excel
  140. Using GetOpenFilename
  141. Linking a Word Table into Excel and sorting it
  142. Pivot Table Question - Using Calculations
  143. OptionButtons and Arrays
  144. Matching/Adding
  145. Macro's failing after renaming sheet
  146. Print and Save
  147. Customised Help file eg xx.chm
  148. Move row to the bottom of the list
  149. Sheet2 to contain only those rows where Actual/Budget is >=100%
  150. Storing State in Excel Workbook.
  151. is there a code character line limit?
  152. populating listboxes
  153. Links can not be updated...
  154. For...Next loop
  155. Is it possible to convert text in a cell to a url?
  156. Find function in specific column
  157. Email from Outlook
  158. Correct Useage of .FindControls
  159. Assigning a Marco to a Drop Down List
  160. Pivot Macro Issues
  161. Debug Problem, possibly involving sheet names?
  162. Check selected cells are right of active cell
  163. Call Action From A Command Bar
  164. Text Parsing??
  165. Hiding/Unhiding columns based on a dropdown list
  166. Preventing workbooks opening into same Excel
  167. ClearComments Macro - whole workbook
  168. varying filename
  169. Select a variable number of rows
  170. Set a value for a userform label
  171. Making Forms Perform
  172. Record a macro, activate by button
  173. Solver: no solution
  174. Updating links requires passwords
  175. Editing a macro to print additional rows
  176. saving in xhtml format
  177. Hiding selected rows
  178. Changing user defined variable types
  179. Weekday dates
  180. Currency Conversion
  181. Excel Hangs When PrintPreview
  182. Change UserForm Depending on ActiveSheet?
  183. Generating ComboBox values from pivot fields...
  184. Looping I think??
  185. Why my macro shourt cut is not working
  186. converting to range datatype
  187. PDF to Excel
  188. Which user has locked the workbook?
  189. ListBox item select default
  190. Find the previous row selected?
  191. How to mask unnecessary spaces from a cell
  192. Custom fill color scheme & conditional format
  193. Userform option choose directory where database resides
  194. remove custom buttons
  195. copy sheet without changing name of shapes
  196. Pivot Tables Page Header
  197. copy tiff file from its url to my disk
  198. Auto Calculate
  199. Centering a cell on the screen
  200. Delete Rows & Column Per Conditions....
  201. Column Search for Data
  202. Running an SQL statement into Access from Excel
  203. Using "text" in activecell.formula
  204. Import with troubles
  205. 3 quick questions
  206. Excel automation
  207. Renaming Tabs with Dates
  208. Simple VBA to set Active Printer up
  209. using a variable in a R1C1 formula
  210. copy dynamic range from multiple workbooks/sheets
  211. expected number error?
  212. Check for empty cells but ignoring value ZERO
  213. Automatically Run Macro every 5 mins
  214. Stop Workbook_Open macro
  215. web query
  216. if statement for sumproduct
  217. Adding the contents of rows with the same date
  218. Access Oracle field which is a adLongVarChar
  219. Changing a hyperlink based on another cell's value
  220. setting class module names.....
  221. Updating Status Bar
  222. Declaring variable names dynamically
  223. reference to external data sheet
  224. Drop down menu formatting
  225. Autofilter using ListBox problem when protected
  226. User Form change font colour on entry
  227. Hiding a row (Including tick boxes)
  228. Auto Insert Blank Row For Each Cell That Ends in....
  229. Autofilter based on the active cell
  230. Run-time Error 1004
  231. Processing Cell Information
  232. Filling in text to the left and right of a cell
  233. Verify If Selected Rows For Deletion Are Within Allowable Range
  234. Excel Alert notification
  235. Call sub or userform from hyperlink
  236. Input Excel Username
  237. Make Range UpperCase
  238. Date format
  239. Problem with date formatting
  240. Create a Directory and set Hidden Property?
  241. Goal Seek with VBA
  242. Using a listbox to go to specified column
  243. Copy Hidden Sheet to Open Workbook
  244. Training Profile
  245. Auto_Open Macro problem
  246. Using VBA to count rows in text file and output results to an excel spreadsheet
  247. Multipage Control - Vertical Option?
  248. proper date format
  249. Inserting a row above a specfic row and hyperlinks
  250. Last row on every page