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. Filtering with multiple criteria in certain column
  2. Copying Columns Across Worksheets
  3. Pivot Table Using Macros
  4. [SOLVED] With for multiple ranges (not using Union)
  5. [SOLVED] Highlighting a Cell, based on value / blank.
  6. combo box input to choose worksheet
  7. [SOLVED] Multiple formats inside single text box (activex)
  8. Massive Spreadsheet... need help with
  9. [SOLVED] Textbox background color
  10. Problem: How to run Excel Solver while viewing a graph?
  11. [SOLVED] Range Does Not Select
  12. [SOLVED] Autofill in Macro
  13. compare lists, highlight matches
  14. Separate Table Data and List Groups in Rows
  15. [SOLVED] comparing 2 ranges.....problem
  16. Need a macro formula
  17. [SOLVED] Formatting Automated Header
  18. How to Set a Cell To a Default Value
  19. Obtain adress book from exchange server
  20. Error while open excel in another computer
  21. [SOLVED] Returning totals in a series of tables
  22. Adding in Excel Dates
  23. Grouping and sorting data
  24. [SOLVED] Save as macro with location prompt but fixed file name ?
  25. [SOLVED] Find/create missing codes
  26. Increment value if another cell is populated
  27. Retain control
  28. [SOLVED] Hide Column if Cell value is null ("")
  29. Checking for an empty array
  30. VBA security
  31. cells.find after without wrap?
  32. [SOLVED] Transfering Data Between userforms
  33. [SOLVED] object variable or with block variable not set
  34. [SOLVED] How to determine using vba if any data is present in the col
  35. [SOLVED] copy/paste entirerow based on listitems
  36. [SOLVED] VBA test to determine if cell has a formula or value
  37. [SOLVED] Color Cells Automatically..
  38. [SOLVED] add 1 to cell value through module / macro
  39. [SOLVED] match entire string
  40. Need to execute VBA code @ 9:30:01 exactly
  41. [SOLVED] type mismatch
  42. [SOLVED] Specify Range with Dynamic row/col
  43. Pass an array by value?
  44. [SOLVED] Different SORT based on data entry
  45. [SOLVED] handling blank input box
  46. Cell Data Type
  47. TextBox Help
  48. Autofilter in Userform
  49. [SOLVED] Make code faster/better best practices
  50. disable all menus
  51. [SOLVED] Automatically Format Cell Border
  52. [SOLVED] Filter data for email only
  53. [SOLVED] last row or col with out activating a sheet
  54. Searching for letter combinations
  55. Removing Named Ranges
  56. [SOLVED] Can't Scroll back to top
  57. Saving Variables with a Worksheet
  58. sapi to read time in normal format not as serial number
  59. expand file name with cel name
  60. Active sheet / cell programming question
  61. [SOLVED] what code can delete cell content
  62. Checkbox and Submit button
  63. One row of input, two rows of outputs
  64. [SOLVED] Deleting Columns
  65. Running vbs script from an excel macro
  66. Macro for making a separate row for two or more clubbed item
  67. Create worksheet for each item in a table
  68. Import ASCII Files into excel, manipulate and graph
  69. [SOLVED] spinbutton unprotect
  70. copy and paste macro!
  71. Macro For Hyper Link Image
  72. Viewing Size of Drop-Down List
  73. [SOLVED] Code to stop scroll
  74. code tidying
  75. [SOLVED] Adding formula to cell using VBA which has "$" in formula
  76. [SOLVED] trying to change a txtbx in module
  77. making my spreadsheet secure as possible
  78. How to add signature to the email through VBA excel
  79. Modeling of a clocked memory element
  80. [SOLVED] Using "text" command in VBA code.
  81. [SOLVED] Making asymmetrical information symmetrical (VBA)
  82. [SOLVED] Mass data transfer
  83. [SOLVED] Macro copy & paste highlight error
  84. Delete All Rows Following Selected Cell
  85. Send excel workbook on a schedule in Citrix
  86. [SOLVED] Reset number to "0" on Mondays
  87. Copying from one spreadsheet to another [Advanced]
  88. [SOLVED] Userform with Time Field displays Time as Number
  89. sort by column prior to my code
  90. comparing 2 cells and populating the value of the compared cell to another cell.
  91. Using Coding to Autofill
  92. Reset ALL right click menus in Excel 2007
  93. [SOLVED] disable red X but keep enable file - close working
  94. Comparison error of two numbers because one is actually text
  95. [SOLVED] Save xls with date appended to end of filename
  96. [SOLVED] return cursor to predefined area
  97. [SOLVED] automatically copy and paste values
  98. [SOLVED] Highlight rows if cells contain specific values
  99. [SOLVED] Macro to file values & formats, & alter protection
  100. [SOLVED] How do I move only value producing formula to another column ??
  101. [SOLVED] Number store as text & text date with 2 digit year problem
  102. [SOLVED] Change Case In Visual Basics
  103. [SOLVED] Excel reading entire file, not one line at a time
  104. [SOLVED] Selected Cell within named range?
  105. [SOLVED] Can't open TXT file in VBA
  106. How secure will my worksheet be?
  107. [SOLVED] Issue copying multicell range to destination workbook range
  108. Huge dependant comboboxes question (unique value population, dynamic range etc.)
  109. Generating Monthly Spreadsheets
  110. [SOLVED] VBA Search within a given range
  111. Accessing SQL Compact DB using ADO
  112. [SOLVED] Search/highlight macro
  113. [SOLVED] VB classes in VBA
  114. [SOLVED] Determining total column width of visible cells
  115. Search Worksheet, Copy Row and Paste Data
  116. [SOLVED] Macro to AutoFilter based on current date
  117. Copy range from one sheet to next available row on the different sheet
  118. Insert row
  119. Use list box to control/sync pivot table
  120. Split into different workbooks
  121. create macro to rename worksheets in other folders
  122. [SOLVED] Data too long to display in the cell
  123. Application.wait error
  124. Dynamic Row Color Change w/ checkbox
  125. [SOLVED] Length of Array question
  126. Merge cells if cell contains certain text
  127. [SOLVED] hide rows If a cell value is zero.
  128. Renaming Worksheets using VBA
  129. How to input a value to a cell using a macro
  130. [SOLVED] Selecting multiple row problem
  131. Value based on colour of the cell
  132. Remove Dupes and Collate date into one line
  133. Macro to check for duplicates and highlight duplicates
  134. [SOLVED] Enhance wordlist through synonyms in Col.D
  135. Object won't take focus after AfterUpdate
  136. comparing colours of cells
  137. Copying an invisible worksheet
  138. Text as audio trigger
  139. [SOLVED] Creating a Range after Creating a Different One
  140. [SOLVED] Copy and Paste Table into String in HTML format
  141. [SOLVED] Fastest way to reference a cell - Range() or Cells() ?
  142. [SOLVED] AutoCalculate set to False?
  143. Web query-recording historical data
  144. [SOLVED] Function to return last modified file
  145. writing a macro to produce data for different intervals
  146. [SOLVED] Hide Row
  147. [SOLVED] Multiplying all the cells in a column by 1
  148. Reformatting Source Data
  149. [SOLVED] Correcting dates in a column
  150. Showing userform when closing previous workbook
  151. Autofill Userform
  152. [SOLVED] Floating Tables
  153. Programmatically adding a row and renumbering subsequent rows
  154. Textbox = %
  155. Splitting Comma Delimited Data
  156. macro help
  157. Multi-Dimensional Named Array
  158. Macro to move data from one sheet to another row by row
  159. Count number of Imported lines
  160. VBA algorithm - convert coordinates
  161. Multipage "scroll"
  162. VBA cell format bug?
  163. macro
  164. Cut and paste as value
  165. Macro Needed to Manipulate Numbers
  166. [SOLVED] Separating the records depending on the value
  167. Search for character, populate a tab, add new info at the bottom
  168. Pasting date values from clipboard - help
  169. [SOLVED] Random number
  170. how to do Bulk find and replace in excel?
  171. [SOLVED] Password Protecting more than one worksheet
  172. Parsing pivot items in Excel Macro..
  173. How to create a summary sheet that returns user selected data
  174. Macro to print on sheets which are not hidden
  175. retrieving and sharing macros
  176. [SOLVED] combining hide columns with autofilter rows
  177. Paste Special (VALUES) Button
  178. Import Data into Excel
  179. Prpblem with addins...
  180. [SOLVED] Compile error
  181. Bug using string variable into Range
  182. Web Query + Pivot Table Problem
  183. VBA to sort rows between values
  184. VBA for sending URL through LOTUS NOTE
  185. [SOLVED] Duplicate check on export of records
  186. Basics of macro
  187. [SOLVED] excel sql import to access
  188. Macro on a calculated value
  189. Play sound file at set time each day
  190. using web query and javascript urls
  191. Selection of range for the 'slope' function
  192. how to use cell value to define range/variable in vba
  193. Userforms
  194. [SOLVED] Need Code for adding Properties Details
  195. [SOLVED] Arranging Data Justified way in equal rows
  196. Conditional maximum
  197. How to use a string variable to define a range
  198. VBA to write new VBA into a new file
  199. Word to excel then result back to word?
  200. Running SQL exhausts PC's memory
  201. [SOLVED] Including hyperlinks that are clickable from a Excel email using VBA
  202. Where to put Sub Chart_Activate() when no chart yet ?
  203. Uncommon File Saving When Macro Is Run
  204. Weird Files
  205. preventing error on vlookup
  206. Advanced transpose macro
  207. Difference Between Specific Events
  208. Cell Shading from other cell
  209. How to use VB to Simulate a Reaction Timer?
  210. [SOLVED] Hide/Unhide columns
  211. refresh form
  212. Auto-compressing specific columns when using AutoFilter
  213. Stacking columns across multiple sheets
  214. [SOLVED] Auto Sort Code
  215. Print Sheets
  216. Importing from Webpage
  217. Coping a range of cell values to the last row of another worksheet
  218. Uncheck checkbox based on cell C4 Changing
  219. Find lowest number in workrange
  220. [SOLVED] Delete Sheets Based On List Using VB
  221. One Sheet Manual Calculation
  222. [SOLVED] VBA equivalent of Weekday()
  223. Using Excel to make a work schedule
  224. [SOLVED] Ultimate Goal: Paste variable sized regions
  225. [SOLVED] Compile Error using TODAY()
  226. [SOLVED] Entry based Execution of Macro
  227. [SOLVED] Access: Combine Query Results to One Table
  228. Copy and Paste Macro
  229. Easy VBA question that I can't resolve
  230. Grouping of cells
  231. VBA to insert VBA into new workbook
  232. [SOLVED] Split a string where the space is???
  233. Updating all pivots when opening workbook
  234. Connect to oracle and fetch the data
  235. Macro to color the date range
  236. Copy value from another sheet
  237. [SOLVED] Take action based on change in cell contents
  238. [SOLVED] Offset for specific cell range(s)
  239. ActiveX Controls on Sheet Resize
  240. [SOLVED] Userform Continued Problems
  241. [SOLVED] email with corresponding addresses and names in body AND subject using gmail
  242. [SOLVED] Copy a range of data and paste to the last row of another workbook
  243. Autofill based on name range
  244. Deleting text from cells with macro
  245. [SOLVED] Updating cells based on List Selection
  246. [SOLVED] Copy certain columns
  247. Print to PDF Files????
  248. VBA Dynamic Forms for a power trader
  249. [SOLVED] Macro prints in landscape not portrait
  250. Email specific range of cells using .htmlbody