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. [SOLVED] Updating cells based on List Selection
  2. [SOLVED] Copy certain columns
  3. Print to PDF Files????
  4. VBA Dynamic Forms for a power trader
  5. [SOLVED] Macro prints in landscape not portrait
  6. Email specific range of cells using .htmlbody
  7. How to add 2 AND 's in a excel macro sql query
  8. [SOLVED] Management of payments
  9. [SOLVED] How to Uncheck a Check Box Based on changes in Merged Cells
  10. Naming a range that is changeable
  11. A different border problem
  12. Border formatting problem
  13. [SOLVED] Using Trim on a selection
  14. [SOLVED] How to set reference to NOT OPENED workbook
  15. Macro to post one file in another
  16. grouping objects then copying and pasting onto another sheet
  17. [SOLVED] Pivot Table Script Change
  18. Changing cell color based on date in cell
  19. [SOLVED] Yesterday macro worked, today it doesn't?
  20. [SOLVED] File not found: VBA6.DLL
  21. [SOLVED] Add a remove button to form
  22. selecting DB table columns.
  23. Reading Excel 2003 into Excel 2007
  24. group part numbers, blank line btwn unlike
  25. Formatting outline of cells
  26. [SOLVED] Code to automatically insert space in a string
  27. [SOLVED] Using a variable to set the end of a for loop
  28. [SOLVED] Check if a value is a named range
  29. Go to next cell that's not empty
  30. [SOLVED] Reference to active row
  31. [SOLVED] Copy selected sheets
  32. Running a Macro from a different Workbook question.
  33. Hide or disable the 'Close' button
  34. Adding text to a cell based on validation list
  35. Macro to update graph source data
  36. [SOLVED] using a vlookup function in a Macro
  37. [SOLVED] search folder for file
  38. [SOLVED] how would i add a space to this line?
  39. [SOLVED] Copy with Condition
  40. How to count the No. of times a document is viewed.
  41. Operatives in Macros
  42. Launching pdf files in a macro
  43. Naming Worksheet tab from another worksheet tab in another Workbook.
  44. [SOLVED] Unload Userform Picture
  45. [SOLVED] vb code using quotes
  46. Optimizing Excel macro to find/replace with the list of data contained in the macro
  47. Query regarding Radio buttons & checkboxes
  48. Right click on tab, move or copy: Disable?
  49. Select a worksheet
  50. [SOLVED] Do...Loop Error
  51. A Way to Querry,(x).Xls files in (x)subfolders
  52. 80th percentile
  53. Macro to save sort criteria
  54. [SOLVED] Curser control with Userform
  55. Open Text Files
  56. Sorting 2 similar columns and retaining row details
  57. Excel VBA that gets commands from cells
  58. [SOLVED] Replicating sheet and renaming
  59. File location changes
  60. Macro for Dynamic Named Ranges
  61. calculate the mean value in macro
  62. [SOLVED] comparison issue
  63. Problem with column fill code
  64. match values between 2 columns then copy
  65. [SOLVED] Activate Userform When A Cell is Selected
  66. [SOLVED] Using array variable to populate range
  67. Create a log file of who has opened spreadsheet and when
  68. Looping through ASCII files
  69. [SOLVED] Adding Character To End Of Each Row
  70. read cell to userform
  71. Use VBA to update/edit another VBA Macro?
  72. Import worksheet data to outlook calendar events
  73. [SOLVED] Select Tabs based on cell entry
  74. [SOLVED] how to delete unnecessary rows ??
  75. [SOLVED] Range Object Question...
  76. Use VBA to shade a cell and then lock
  77. [SOLVED] executing two different commands with same button
  78. [SOLVED] Improved Word Count Macro
  79. Unprotect Sheet code not working
  80. Excel to Form
  81. Copy to clipboard button on / paste special button.
  82. [SOLVED] Macro to delete columns if they contain data - need help creating
  83. VBA Trim
  84. [SOLVED] Avoiding exponential numbers during import.
  85. [SOLVED] Formatting textbox
  86. [SOLVED] an easier way to save with a button?
  87. Run code saved in PERSONAL.XLSB
  88. [SOLVED] Combobox problem in shared workbook
  89. Help w/making this list Parent directory,Subfolders,and files
  90. Manipulate Multiple Controls with 1 Procedure?
  91. [SOLVED] Pivot table pop ups
  92. [SOLVED] VBA wont export values with leading zero's
  93. Combine functions of 3 Buttons into 1
  94. transfer data from open workbook to closed workbook
  95. [SOLVED] Combine data in two worksheet into a third worksheet
  96. Corrupt Excel File
  97. [SOLVED] Creating Buttons using Excel VBA
  98. Macro to delete text from within text boxes
  99. Automating IE JavaScript Form
  100. Formata date in TextBox
  101. lookup and sumif?
  102. Macro to unhide/hide sheet(s)
  103. [SOLVED] how can I move one cell to another?
  104. [SOLVED] Macro to return yes or no based on multiple cell dates
  105. Embed combobox and look up values based on combobox value
  106. [SOLVED] Copy entire worksheet including all Macros and VBA Code
  107. Mark checkbox if cell has certain value
  108. multiple formulas needed -
  109. Add additional text within copied sheet name brackets
  110. Cell Protection based on cell color
  111. [SOLVED] macro to transfer values from cells
  112. [SOLVED] Stop macro functioning on sheet1
  113. [SOLVED] Advice on form layout.
  114. Sum in TextBox
  115. Selecting a named range in VBA code
  116. Linking two ActiveX Drop-Down ComboBoxes
  117. VBA - if control is not locked
  118. Conditional Formatting Fill colour with weekday colour
  119. Text File Manipulation
  120. VBA Import from Outlook Calendar
  121. [SOLVED] copy find-paste
  122. [SOLVED] Input box not todays date
  123. [SOLVED] Drop downs & filters
  124. [SOLVED] check box - Select all
  125. Automatically populating cells in a worksheet based on other worksheet column
  126. Macro required based on column value
  127. worksheet_change event delete contents
  128. [SOLVED] Run code automatically, not with button
  129. Files Opening and Editing via macro
  130. How to copy columns to new sheets based on condition?
  131. [SOLVED] Split File
  132. [SOLVED] Last Button and Add Button on Userform
  133. Opening Outlook Form Library
  134. Macro Shortcut
  135. [SOLVED] Using If Statement in VBA Code
  136. capture part of a text in VBA?
  137. .SetFocus Not working properly
  138. [SOLVED] Is it Possible to use "AND" or "OR" type expressions in VBA IF statements?
  139. [SOLVED] Using VBA to link Radio Buttons to Display an observation
  140. [SOLVED] loop or macro to retrieve rows of data from other worksheet
  141. [SOLVED] Select rows until blank row
  142. [SOLVED] IF/AND question
  143. Using MS Query to run Query on Worksheet in the same Workbook
  144. Excel Macro To Compare Date and Send E-Mail
  145. Pivot table on new sheet
  146. Variables Go Nowhere
  147. VBA to get network IP
  148. fil.Type = "Microsoft Excel Worksheet" also shows pst file?
  149. Import problem
  150. ListBox Enter key
  151. PageWidth Output
  152. [SOLVED] Multi-Page userform controls
  153. [SOLVED] Can a Worksheet_Change Range permanently adjusts itself
  154. [SOLVED] Macro doesn't work on button, but fine from Macro menu!
  155. Pivot table chart on same sheet
  156. Code for reversing print order
  157. Importing data from TSP/Tour-file
  158. VBA for exporting and appending specific cell contents to network drive
  159. Copy data from excel file to Web Form automatically
  160. Macro only runs on my computer
  161. [SOLVED] Controlling Screen flashing using LockWindowUpdate
  162. [SOLVED] Copying and pasting using VBA
  163. [SOLVED] Macro to Print document based on cell data
  164. [SOLVED] Macro new sheet creation
  165. [SOLVED] Change a cell in a worksheet using VB
  166. [SOLVED] Copying row
  167. [SOLVED] Error 1004. Paste method..
  168. [SOLVED] Copy recent cell value and paste in the next empty cell down.
  169. Convert from text to numbers
  170. activate or deactivate a cell based on the option selected in validation list
  171. a small problem with setting a hyperlink in a text
  172. [SOLVED] Print macro & Printers
  173. using Properties dynamically
  174. Macro to automatically back-up file and alternative for VLOOKUP formula
  175. eliminate duplications
  176. macro that sorts and counts on the condition of a text string
  177. [SOLVED] My Own fiscal month
  178. How to find nearest date to that of given
  179. [SOLVED] "Do...Until" problem (Error 1004)
  180. [SOLVED] "FIND" method Macro not working
  181. Copying code from one book to another
  182. Delete all rows in a worksheet that do not begin with **
  183. Create new worksheets with names
  184. Find Data & Paste in pervious column on multiple sheets
  185. [SOLVED] NOON for 12:00 PM
  186. VBA in Excel 07
  187. [SOLVED] Ranges question
  188. Calculate Cost Basis of Inventory
  189. [SOLVED] Userform to edit data
  190. [SOLVED] Hide/Unhide Checkbox using another checkbox
  191. about dispinterface in excel type library
  192. save first sheet only
  193. error message box
  194. Object 424 Error
  195. Adding row
  196. Help required for a green Thumb
  197. Returning values from the RUN command/method
  198. text and number filter
  199. Why does this code take so long to execute?
  200. Selecting 1 static cell and 1 variable cell
  201. [SOLVED] Input based macro
  202. Spreadsheet to .pdf
  203. Convert text fields to numeric
  204. Formatting Text in Text Box Control Error
  205. [SOLVED] Autosave / Autoclose after inactivity [Roy's Code]
  206. Copy to a new File without Macro Code
  207. programming a new Command button
  208. [SOLVED] Learn coding
  209. Lookup only non null values
  210. Setting ChartTitle Sometimes Results in ArgumentException
  211. Loopin Through Ranges
  212. [SOLVED] Spreadsheet runs slow
  213. macro to move a number to another cell
  214. New to this... a little help?
  215. [SOLVED] Trying to Cut Row from One Worksheet and Paste in another Worksheet
  216. [SOLVED] Paste in 9x16 arrays of data
  217. [SOLVED] Paste Data from one sheet to another sheet in same Column
  218. select range of cells and replace
  219. Want function to use data from the calling worksheet when workbook is recalculated
  220. [SOLVED] Adding color to freeform scribble
  221. Changes Not Getting Saved
  222. [SOLVED] Type Mismatch error
  223. creating exectuable file for VBAproject.
  224. to display a graph in a VB userform
  225. Sum from different condition
  226. macro to delete the positive value from pivot table
  227. [SOLVED] date format in VBA user form
  228. Report of a Table
  229. Macro goes back to the original tab.
  230. [SOLVED] speeding up print formatting(Header + Footers)
  231. Formula, Paste special and Formating in one line
  232. [SOLVED] Cell Data In Print Header
  233. Make all files in a folder read only using excel VBA
  234. [SOLVED] Copy formula to all worksheets
  235. Command Button Formating
  236. [SOLVED] how to empty all elements in an array
  237. Conditional Calculation
  238. [SOLVED] Delete Duplicate Rows
  239. [SOLVED] Specify a Cell Range in Change Event
  240. Conditional Formatting with 4 condtions
  241. Protecting a Sheet with a List
  242. [SOLVED] Data Mining
  243. Userform Problems
  244. Manage minimum payment due Macro
  245. [SOLVED] Macro for alphabetizing... more difficult that it sounds
  246. Simple Macro to Open Files....
  247. [SOLVED] Conditional Cell Color Change For Multiple Cells (Please Edit)
  248. Copy and paste macro
  249. [SOLVED] Check a range of cells for empties
  250. manipulating code and adding code to produce pdf