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. Write textbox value to cell 'on-the-fly'
  2. Obtaining The Functions Cell
  3. Value of cell + 1
  4. Macro for pasting, deleting, and shifting data
  5. Default Color For Cells
  6. Simple excel program
  7. Case without select case error
  8. go to end of data and insert data in next row
  9. Format Formula
  10. copying only data and not formula?
  11. copying various cells in ot different cells in a different sheet
  12. my posts
  13. Lighter shades of Grey, Printing
  14. write formula
  15. vb and access
  16. Which user has modified a worksheet
  17. Complex validation help
  18. Combobox Problem
  19. macro to compare rows
  20. Macro gives error 1004
  21. Problem with opening document from Excel
  22. how to set formula in worksheet
  23. Trouble using GET.CHART.ITEM on 3D Column Chart
  24. Syntax Query
  25. Question re combo box
  26. Clearing list box on userform
  27. MismatchError: Copy Text to Textbox Using Characters Method
  28. Please help! Scrollbar in Userform
  29. Help determining best approach
  30. vba cells.find problem
  31. How to delete every other cell?
  32. Delete unused rows
  33. Move input data without altering formulas that reference it
  34. Import a .txt file , and how do I get started in VBA
  35. Speed Up Macro by Removing Select Commands
  36. Limits on Variants, strings, etc?
  37. Making interactive query results using VBA
  38. Moving data with VB code
  39. Name of Named Range
  40. Getting debug error when trying to do a "find"
  41. Out of string space...
  42. Relative Autofilter using Named Ranges
  43. Object Variable or With Block Variable Not set
  44. Help modifying code please.
  45. VB Code to replicate data ?!
  46. Deleting rows matching a rule
  47. Copy selected row
  48. Conditional Sum in VBA
  49. Context Menu within the VBE
  50. Activate the Enter Button
  51. print out
  52. Dropped Values
  53. Reading a range of values from a spreadsheet into a VBA array
  54. Macro upgrade
  55. Read .txt file
  56. Reading HTML tag content into Excel
  57. Add Condition To Macro
  58. Using goal seek to make a chart
  59. smart macro
  60. Weibull within Excel
  61. Sorting Pivot Page items based on others
  62. covert integer to column reference
  63. Highlight Cells if Value Equal to a Certain Amount on Subtotal Lines
  64. macro to select next in data validation list
  65. Macro to Create a Button
  66. Combo Boxes in Visual Basic and excel
  67. Move colum data to row then delete those rows
  68. Message Box tied to System Date
  69. Data Entry thru a Macro
  70. Creating a combo box in vb from data in excel
  71. Error when updating links via VBA
  72. String method
  73. Custom VBA function help text
  74. select the cell that was active before it ran
  75. move selection from a sheet to new workbook
  76. Copy Folder Using Browse
  77. Find the file path only
  78. .Find Method results issue...
  79. looping through a range of cells in excel
  80. Missing Module
  81. Transfer function forecast/fuzzy logic/iteration
  82. Vlookup
  83. Formula help
  84. vba api
  85. vlookup
  86. Trap Error In A VLOOKUP List
  87. Enable / Disable CD-ROM thru VB
  88. How to make to rows in cell
  89. Help With Macro Output In Cell
  90. Tab within Java Applications
  91. "IF(A2=A1+1;B1+1;1)", possible to recognize same date? it's an ICU research
  92. Problem with VBA Buttons page copying
  93. question with if statement
  94. Macro to Add letter preceeding Name in cell
  95. Saving Multiple Worksheets as Text
  96. Renaming Multiple Worksheets
  97. validation
  98. How to Call a 2nd Macro w/i the 1st
  99. Adding TextBox Values
  100. Help reading .txt file
  101. excel 97
  102. List box in an Excel sheet
  103. rows to copy
  104. Find Within Single Column?
  105. excel problem with web
  106. VBA that removes duplicate rows
  107. Macro for Removing Rows?
  108. Merging Excel reports based on common field
  109. vb and excel
  110. Insert Comment in Cells Automatically When Countif Returns a Value
  111. Text to columns
  112. access db
  113. check data
  114. Cell checks and cell ranges
  115. Changing Default Color Of Cells
  116. Automating Solver function
  117. How to have Checkbox A uncheck with checked Checkbox B
  118. Help needed with Access Recordset
  119. Code that Deletes Itself
  120. Excel crashes when I create code through a routine
  121. Class does not support automation (err 430) - on copyfromrecordset
  122. Macro question...Thanks for looking
  123. Email macro with no email addresses
  124. macro for changing source of graph
  125. Macro to Fill Blank Cell with Values above.
  126. Problem with Macro Recorder
  127. Newbie VBA question
  128. Button with macro help
  129. Not Enough Resources To Display...
  130. Need Macro to adjust formula
  131. create hyperlink in a cell with a filepath as content.
  132. Code for auto filter and arrange specified cell values in matrix
  133. Chart data selection manipulation
  134. copy paste macro
  135. environ to get windows sign on
  136. Wildcards
  137. anyway to increase the size of input text?
  138. how to project #value! as zero?
  139. Paste
  140. AfterUpdate event for dynamic TextBox
  141. Refering Forms Across Workbooks
  142. how to use vlookup/macro programming for this issue?state price accroding droplist
  143. Extract Duplicate Value to last column
  144. Simpler way to do declining balance?
  145. Monte Carlo Simulation
  146. Excel Help
  147. cut and insert
  148. Record Macro Stop Button
  149. Question regarding Macro for pop-up window with picture
  150. Multipage Form
  151. Find Method
  152. Macro not working
  153. Cell contains contents of another cell
  154. How to make one cell have two lines?
  155. Trying to Break up a Number
  156. Setting MaximumScale
  157. running a macro automatically
  158. Nextrow in another column
  159. VBA Question
  160. Application.EnableEvents
  161. macros for read barcode digit and find
  162. Conditional Filter
  163. pause in module sub for inputting data
  164. Assigning a VBA Userform to a button in a worksheet.
  165. Extracting web data with varying page format
  166. Automatically blank a worksheet on startup
  167. Get the idle time of an excel application
  168. Autofilter & Copy Macro
  169. automatic fill
  170. save as & copy worksheet code query
  171. Need Macro to delete duplicate Values in Column
  172. Help with IF formula, please
  173. Need Help With IF/Then code
  174. Disable Automatic Re-calculations and Adding a Button to do the Job
  175. Change this code to read rows, not column?
  176. Autocomplete passwords to linked files
  177. Passing in values
  178. Multiple If conditions
  179. Recalculate In Loop Importing Bloomberg Data
  180. Adding The Row
  181. Macro on button click
  182. List Boxes and Blank Lines
  183. Hiding blank rows
  184. Need help programming this excel function?
  185. Match Formula
  186. Copy sheets from one file to another
  187. File name ONLY please
  188. multipage set focus help
  189. User Defined Filter
  190. total in words
  191. Multiple selections from a listbox
  192. Move Down One Row in a Macro
  193. Place Cursor at Bookmark
  194. Problem with Locking cells
  195. Function not Copying Properly
  196. Updating Excel Query after DB moves
  197. Height macro request ...
  198. VBA security
  199. VBA Programming!
  200. Difference between an event driven macro and a module macro
  201. Is there a formula? Is it even possible?
  202. excel's IPMT() logic
  203. selecting a varying workbook name
  204. copy/paste row
  205. Deleting text within a cell
  206. Conditional Replace?
  207. How can I create a list of all queries in workbook?
  208. Select Cells with Data
  209. Separating a Date?
  210. problem with open events and opening several workbooks at once
  211. For Loop STOPS at Random Iteration!
  212. Column Letter from number
  213. User choice to display one value or another dependant on result
  214. Create an add in for a Macro
  215. Variable hyperlinking?
  216. Counting
  217. combo box format
  218. Transfer Functions + PDMs
  219. Code to pick up the last modified file in a folder
  220. names from a list
  221. Copy and Paste Formula in a Macro
  222. confirmation mes.
  223. Excel size getiing very large on small change
  224. Go to certain worksheet on opening workbook
  225. How To Deal With Varying Number of Rows
  226. Module not loading on startup
  227. Adding a row to a defined list (combo box)
  228. Input Box For Numbers And Dates
  229. Macro to Change Formula
  230. VBA: Count Items on the Same Line as Active Cell
  231. Color Code rows
  232. Autofilter
  233. Delete Empty Rows
  234. ComboBox and VBA
  235. Find not working in macro
  236. Displaying an array as columns in a msgbox
  237. Opening a new window for user
  238. Renaming a sheet in vba
  239. Using macros to filter formulas
  240. Delete duplicate rows
  241. vlookup in a macro
  242. selecting 1st empty cell in a column
  243. Pulling through list from different workbook
  244. how to search for * in excel
  245. Application.OnKey problem.
  246. calculating now many rows in macro??
  247. Excel Looping Problem
  248. Ftp
  249. #NAME? error
  250. Quotes in a formula