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. Remove Text From Cell When Image Is Inserted
  2. Remove Text From Cell When Image Is Inserted
  3. footer macro
  4. Userform Help
  5. macro that selects entire row based on criteria
  6. Pivot Table Field Sort
  7. Paste without taking into account the hidden rows
  8. Macro is unlocking locked cells... but I didn't tell it to.
  9. next non-hidden line
  10. Importing Data
  11. Copy Sheet to End
  12. Delete Multiple WS
  13. How to make this macro work for auto range
  14. Is there any way to solve this problem ?
  15. Worksheet change event, ignore multiple cells
  16. Code error, highlight error, continue to RUN
  17. Word mail merge using excel data and chart
  18. Embed Images in excell from UNC path
  19. Macro to PivotTable a SemiPopulated Dynamic Range
  20. User Form With Bar Code Scanner
  21. Check if Autofilter is On or Off in VB
  22. How do you uncheck a checkbox from a cancel button in a userform?
  23. Combobox-populating the linkedcell property programmatically
  24. Run-time error '9'
  25. Personal.xls does not open-download into excel
  26. Counting individual coloured cells that are merged.
  27. Pulling same cell values from multiple workbooks
  28. Running a button from another button
  29. merging using a macro
  30. writing arrays to excel..
  31. Loops
  32. hiding a column based on no criteria
  33. Changing Workbook Code Using a Macro
  34. How do you open UserForm1 with a checkbox?
  35. Form with a text label like a "banner"
  36. Deleting content in cells based on criteria
  37. Enter text into a formula using VBA
  38. Custom Footer
  39. Auto Format
  40. Two Macros - Save Dialog appears in only one?!
  41. Runtime error 1004
  42. format decimals to integer
  43. Limit unprotecting workbook to second workbook being present
  44. Converting a matrix into a single column
  45. Takes way to long to save.
  46. Select Case
  47. sorting a table of nunbers lowest to highest, but exclude zero
  48. Search all rows on Sheet1 for cells in Column "C" that contain "PD" and if found cut
  49. Is there a way to get a value with partial input
  50. extracting records without duplication!
  51. Cancelling Auto complete
  52. Script wont enter after scan
  53. Getting Error 400 with following code. How do I remove it?
  54. Sorting Col A and insert a worksheet
  55. Right Click Pop-Up menu
  56. Using Dates as Strings
  57. adding date to save macro
  58. Copy Macro To Multiple Workbooks
  59. Protect / UnProtect all workbooks with a single button through VBA
  60. Copying a formula to a active range
  61. Pattern index
  62. Getting currency data online?
  63. In need to format a label in an user form
  64. AutoFilter only on specific columns and row?
  65. Run-time error 1004 when sheet is protected
  66. Find and compare a range
  67. VBA code gets 99% of values correct
  68. Counting down to a date/time: how to display?
  69. call another program
  70. separate different data from one column another columns
  71. inserting a sheet into my workbook
  72. new to vba- basic question
  73. Data auto summing
  74. VBA Help Please??
  75. Deleting N/As in range
  76. How to set the size for the new window
  77. Assign Filename, then delete
  78. excel and html
  79. How to get the values from another sheet and calculate?
  80. Find The Macro or Hyperlink
  81. display date last used a macro
  82. Uncheck Radio Button using a Command Button
  83. Macro to return data into a comment
  84. IF statement in a cell which shades it a color or say red depending on whether an adj
  85. Using values in one column to determine values in another
  86. keeping original sheets as original
  87. Hiding Rows
  88. Insert range-named row at user-selected row
  89. Copy&Sort data to different worksheets
  90. possible lookup(?)
  91. New thread for font size & bold
  92. Add, remove to store - moved from Excel Miscellaneous
  93. How to change font size & bold
  94. Detect if File is opened on USB Drive
  95. User Form to enter/amend times
  96. Macro to pull data from multiple files with user prompt
  97. One column, copy text, ignore blanks...
  98. label display
  99. Google Base File Conversion
  100. Need to Paste data into User Form fields or convert
  101. Find() Help
  102. Run Time Error '13':Type Mismatch
  103. Splitting Long Strings
  104. AutoFill, can the last cell in range be variable?
  105. Auto Enter After Data is Scanned
  106. Adding controls in runtime
  107. Standard Menu Bar Missing
  108. Button Help!
  109. OleoObject name variable definition
  110. Compare Data Script To check Names
  111. Date Validation in Form
  112. Jump To Specified Cell When I Hit Enter
  113. No AutoComplete For Specified Cell
  114. compile error
  115. Named Ranges and looping
  116. Alternative code to put formula in cell
  117. VBA to copy and paste
  118. Code to protect wookbook
  119. highlight cells when mouse pass over?
  120. Delete Worksheet If they are there
  121. OptionButton
  122. Copying autofilter criteria
  123. Excel sheet in "full screen" (without any toolbars)
  124. Display lists
  125. Copy worksheet - Easy?
  126. VBA Header format
  127. Exporting excel sheet+macro to HTML
  128. "Code execution has been interrupted" - any ideas?
  129. Activate Excel window if focus lost
  130. Search for cell equal to cell in another worksheet
  131. Tab Name Matches Cell
  132. linking data
  133. Matching values between two ranges
  134. Dropdowns and possible "sub dropdowns
  135. saveas filename=inputbox value?
  136. Combo Box
  137. Manipulating Macro Button in Standard Toolbar
  138. Find Earliest Time For Each Serial Number
  139. before close event
  140. Create array of file names/sheet names
  141. How do I sum up values only in cells that are color filled?
  142. Extracting the data from this format
  143. Runtime error occurs only on 1 out of 4 workgroup users
  144. Passing variables into a SQL statement
  145. Selecting patient data based on multiple variables to calculate mean and SD
  146. Spell Check Script looking at wrong column
  147. If Or Formula
  148. Colors of shapes and cells
  149. Lock a combobox
  150. Need to add a sort command to macro
  151. Data Varification Macro
  152. userform problems
  153. emailing code
  154. excel macros executable
  155. Vb Return to original sheet
  156. copy formula from one cell to another
  157. Highlighting applicants in a specific age bracket.
  158. Forcing the user to make a choice
  159. Insert 4 Rows
  160. Excel expertise for web application
  161. no ordering in combobox
  162. why do macros in workbook try to run in other workbooks
  163. Macro Logic Efficiency
  164. Replacing Items
  165. add, remove to store
  166. Macro to work on external excel files
  167. Taking partial text from a range of cells, cutting it, and pasting it elsewhere
  168. VBA Macro to Export a Macro?
  169. New sheet based on cell value?
  170. Copy Rows To New Sheet Based On Colum Criteria
  171. Lottery Function
  172. automatically answer a prompt
  173. disable VBA Screen
  174. Override shortcut key to non letter
  175. VBA: Creating a UDF that automatically updates as the data changes.
  176. Application.OnTime
  177. Referencing Worksheet Cells
  178. Userform Possition
  179. deleted
  180. Looping through worksheets in a workbook to pull data
  181. Does Not Contain
  182. Referencing Shapes Without Selecting
  183. Where can I find the log files for Excel 2007?
  184. macro menu bar - cannot find macros indicated
  185. Macro that will delete the days from columns of dates
  186. Dynamic Link
  187. Essbase Retrieve - Can't Disconnect
  188. Update the main Tab
  189. Problem in hiddin rows
  190. Reformat source file as table
  191. Macro to change sheet name
  192. on time procedure
  193. Dynamic Scrolling based on partial cell entry
  194. Not sure what I should do
  195. Macro code to insert Blank columns and rename them
  196. Average as Text
  197. Excel/VB connection with Database (have to reconnect everytime)
  198. unresponsive command button
  199. Syntax error 1004 at ".Refresh BackgroundQuery:=False"
  200. Select some rows in a column assigned by a variable
  201. Troubleshoot code - Open workbooks in folder & insert 0 in cells
  202. Extreme problems with solver! Cannot find Linear resolution...
  203. Create array and formula based on 2 different sheets
  204. Excell script to extract from data from pivot which changes in size when opening
  205. Putting a procedure on hold?
  206. copying and deleting text
  207. prevent a specific sheet from copy and renaming of workbook
  208. Matching values in Sheet1 ColumnA from values in SHeet 2 ColumnA
  209. Date formatting for collums
  210. Troubleshoot code to find text.
  211. BoundColumn
  212. Print Macro not working...hiding extra fields
  213. Can you export the UserForm out
  214. info from spreadsheet to few others
  215. Vlookup and Delete Row Beneath
  216. Check Value and Adjust
  217. Macro for Searching Columns
  218. Command Button code
  219. run macro with Essbase retrieve from separate spreadsheet
  220. code worked but not now??
  221. Email Single Sheet/Don't Update Linked Data
  222. Automatically generate Code for a worksheet created by a macro
  223. Change the formula of a target cell in a self-defined worksheet function
  224. Auto Filter
  225. Determine Page Number
  226. Deleting rows problem
  227. Do while loop issue
  228. Disable Print
  229. Excel Run time Error 1004: Copy method of Worksheet Class failed
  230. SHG - VBA macro for date generation
  231. Invert last name / first name (not comma separated)
  232. Difference in dates by range
  233. How do I modify this code to find text?
  234. Auto Find/Replace + Marco sort?
  235. Macro to copy formula in D1 all the way down column ‘D’ until the first empty cell
  236. Sorting certain sheets alphabetically
  237. Entering worksheet data via user form
  238. Splitting Date & Time into two seperate columns
  239. Code not allowing to view progress
  240. Calculating values in multiple textboxes
  241. Warning message and ExitSub
  242. Date Problem
  243. Private, lock together.
  244. comparing rows in excel for a given column value and highlighting the difference
  245. Comparing Data Between two Columns
  246. TRIM spaces in between word in one cell
  247. macro script to collect pivot data
  248. Macro to Remove "Seconds" From Timestamp
  249. jump to the next row with macro
  250. Adding Time