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. Can't figure out loops
  2. Very super Hidden
  3. Workbook will not share
  4. Does a "hasNext" boolean exist for worksheets?
  5. Change text color wth an If statement
  6. How to Copy WS Names to List in New WS?
  7. Right to Left Formatting
  8. macro graphs
  9. vlookup in VBA
  10. custom cursor navigaion
  11. List all Named ranges in a sheet?
  12. VBA Script Guide
  13. Accessing a closed xls file from a macro
  14. Assign value to string?
  15. Target Row is off by 1
  16. calculate formulas based on top 20%
  17. Chart to ignore zero values - can it be done
  18. Help with Lotus Macro Conversion
  19. How to find empty cells and copy data from other cell ?
  20. create a list in file 1 with data from file 2,3,4...n
  21. Error in Code
  22. Convert column in row on criteria
  23. Application.DisplayAlerts = False showing True
  24. selecting rows that match imput box
  25. Advanced Filter, nested =IF function, or possibly some other tricker *please help*
  26. ActiveWorkbook.Unprotect not working
  27. Developing a Combination of Columns within Excel, using Macros
  28. Sort using keys not in range
  29. Adding Code At Runtime
  30. macro for multiple spreadsheets into one
  31. multiple columns of data stacked into one column
  32. Get data from several closed xls files
  33. Copy row based on criteria
  34. Array is not being cleaned up
  35. Conditional chart help Excel 2007
  36. Trying to declare a decimal
  37. new to macro editing: how to force the selected cell?
  38. Trying to insert rows
  39. Insert a picture from scanner or camera macro? - WordBasic.InsertImagerScan?
  40. Major data manipulation problems
  41. Having Excell automatically give me corresponding information from another Row
  42. Tricky Comparison
  43. Basic 'or', 'and', 'not' Question
  44. Max difference between two sets of numbers
  45. Macro: waiting for Bloomberg data to update in Excel
  46. Set chart axis title within Macro
  47. Search Box
  48. Creating a "confirmation" box in VBA
  49. SaveAs not working
  50. Deleting based on IF formula code question
  51. One to Many type Drop down control
  52. Search folder for files containing "Temp", delete files
  53. Importing Data from different workbooks
  54. I am trying to subract X Hours from a data/time value
  55. Getting day from date
  56. Deleting Rows based on their value
  57. Passing Array's As Parameters
  58. double clicking on cells to filter data
  59. Select / deselect pivot table fields with check box
  60. set chart range via button macro
  61. Macro To Save Automatically
  62. running macros on protected sheets
  63. Solver constraints not added through VBA
  64. copy formula in cell based on criteria in other worksheet
  65. Find date. Vlookup, Find, Match ?????
  66. Cells value insert into macro Formula
  67. MOD Function in macro
  68. unable 2 call another macro from workbook_open using Ontime()
  69. External data queries...
  70. Inserting rows from list
  71. Find closest match unsorted data
  72. Display Msgbox on 1st of Every Month
  73. Check day of the week
  74. Simple Macro Help
  75. Add code to row using VBA
  76. Load Contents of array into Range
  77. Additem Method not working
  78. Using Named Range in VBA
  79. being able to select a varying numbers of colums from a formula using a macro
  80. correlating month to number
  81. Strip Macro from copied object ?
  82. macro with SQL
  83. password protection again (sorry)
  84. Need to create a macro to insert row after a value change in a column
  85. Copy and paste and keep EXACT formatting
  86. startup macro for new menu item from a template
  87. Excel Macro deleting rows contain "0"
  88. Mouse over button message
  89. Open a folder for viewing from a UserForm
  90. Print Range ---macro
  91. Linking Worksheets
  92. Need help for macro to automatically sort every 5 rows
  93. account # altering macro question
  94. Disable or remove macro's on close
  95. Import Multiple XML Files
  96. Chossing data for graph
  97. Export sheets to new workbooks
  98. Fill cels based on some criteria
  99. How to insert empty lines and code using a Macro
  100. Textboxes and cell programming update edit etc.
  101. Removing Userforms
  102. code to reach rightmost unused cell in a row...
  103. Populate range from VBA
  104. Interpretting "=COUNTIF($A$2:A8,A8)=1"
  105. How to display form for set length of time without maxing cpu?
  106. Select and copy cells based on values in another cells
  107. Userform Multipage Help
  108. Excel 2003
  109. Automatically Transposing Rows to Columns on a Mass Level
  110. How To Use The Count Function Like This?
  111. Making the same drop down box display different sets of choices
  112. Find/replace macro help
  113. copying multiple columns into one long column
  114. Macro to create new sheet based on value in cells
  115. UserForm for an expense report
  116. Filling out calendar based on another sheet
  117. dates converting to serial numbers
  118. VBA Request - List in single cel to individual rows
  119. startup macro for filename, possibly macro name
  120. displaying cells on a form
  121. Find word in column and copy cell to the right
  122. worksheet change code not working
  123. Extract specific text from cell to save file
  124. 'frozen' structure that simulates cashbook
  125. running macros on protected sheets
  126. new sheet named vba
  127. print folder and directory selection
  128. 'IF' formula=true if subject is BOLD
  129. Excel VBA Help - Referencing across sheets
  130. find and replace a hyperlink
  131. find, copy and edit range
  132. Email Macro
  133. Insert and name new sheet using UserForm
  134. Drop Down Box Help
  135. Identify identical files names w/ different url paths
  136. Bloomberg Calendar>Excel
  137. Delete Object when Object number unknown
  138. Check if users are connected to a database
  139. Private Sub Worksheet_SelectionChange
  140. Using Find method to find the closest value.
  141. Take out / ' / this character from a cell
  142. Help creating a program
  143. Activate-Deactivate worksheet buttons
  144. Keep Only Columns Containing
  145. Using Find Command, having What: equal to a cell on a different workbook
  146. Doing multiple calcs in VBA
  147. Create combobox list from autofiltered range without advance filter.
  148. Revisions to Macro
  149. Create Running Log when Financial Model triggers Buy / Sell Orders
  150. Checkbox and recalculate
  151. txt files sorted in excel
  152. find word and highlight
  153. Hide/Unhide rows based on 3 cells values
  154. Yes/No Message box
  155. PageBreak and Insert the value in Header based on a cell value (Lookup)
  156. hiding columns with overlapping macros
  157. Macro Run automatically
  158. Search a word and highlight
  159. Delete Sheets on close macro
  160. problem saving a protected sheet
  161. Worksheet activate code in Add-in
  162. Keep Only Rows Containing
  163. macro to shade alternating rows
  164. Edit Links When New Worksheet Added
  165. Macro Pivot Table vs Manual Pivot Table - different results
  166. New to macros, looking for logic assistance
  167. Importing CSV - bug when file is empty
  168. Macros are not working on a Mac
  169. Link worksheets when additional data inserted
  170. how to email a worksheet ??
  171. Undoing macro on error
  172. Open and print
  173. Help in IF Formula
  174. Hit Counter Odbc Source Browser Viewed
  175. Defining dynamic range with VBA
  176. MAC excel 2004 read only and tool pak issue
  177. Progress/Counting Meter Problem
  178. How to mark duplicates cell with 2 columns ?
  179. Delete Entire Row, but keeping the Formula in tact
  180. Disable Cut, Copy, Paste in a workbook
  181. Find and replace script / macro?
  182. Macro to add images in comments
  183. Macro to update quantities in range
  184. Balancing Figure with Paste special in a certain cell
  185. Basic UDF Question
  186. Drop Down List Question?
  187. New to Excel programming, looking for a hand
  188. automatic erasing of field entry and date entry
  189. sheet to sheet next property
  190. writing function in VBA
  191. Insert graphic from userform
  192. Variable names assignment
  193. Initialized Form Life
  194. (Link) Data repeating in pivot table...
  195. Filter
  196. Transfer Array values to a range and Vice Versa
  197. VBA code for PCA
  198. user defined function works in VBA but does not work inside worksheets
  199. Hide Password
  200. after closing and opening the worksheet the vba code not working
  201. Message Ticker Creation
  202. Data Validation
  203. Sum number portion of alphanumeric cells
  204. Copying formatting across sheets
  205. VBA to rename Chart titles with Worksheet names
  206. Sort 2 levels thru VBA - in a protected sheet
  207. Unusual Number Format With DDE
  208. VBA to rename worksheet based on cell reference on another worksheet
  209. Grouping columns based on a value in a cell
  210. Save an Excel game?
  211. Opening all folders
  212. Create hyperlink
  213. Error with On Error?
  214. data in file a will also show in file b VBA programming
  215. VBA & PivotField Code
  216. Help with Macro to save
  217. need to find addon - new function
  218. Hide rows based on a value in cell A1
  219. copy column of data, remove blank cells
  220. print the hiden portion from a worksheet by clicking button
  221. Hide column depending giving value in another worksheet
  222. Modify This Code for WorkBook Loop
  223. How to remove cell value in VBA
  224. How to copy a cell's color to other other cell?
  225. Copying a cell down to the end of a list
  226. Writing Multi-Dimensional Arrays to Ranges
  227. Formula/macro question
  228. Command to make Excel open invisible?
  229. hiding columns via Macros
  230. Code To Open a Workbook- Anyone Know??
  231. how to have a worksheet respond to an anomaly
  232. Macro to Find if a certain worksheet exists
  233. Somewhat Complex Tallying
  234. Insert picture and resize to range of cells
  235. Create 2 Totals, One Based On Name And One Based On Name And Cell Fill Color
  236. i need help to find a function
  237. update macro
  238. macro: changing cell color based on date in cell
  239. Losing Copied Cells from other Workbook
  240. Create Calendar from "date" column
  241. Extract name and create a hyperlink
  242. code for variable filepath
  243. Macro - fill cell
  244. VBA User Form with Excel datasheet
  245. Macro to cleanup data
  246. Macro Chart Confusion
  247. The midnight hour
  248. Is worksheet empty (blank)
  249. Delete Row if date is greater than or equal to 6/6/2008
  250. Freeze Panes Macro