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. VBA Code
  2. Need some help
  3. How to count number of sheets?
  4. How to report number of UNIQUE cells on new sheet?
  5. Public Variables
  6. How to add a check box for each sheet added?
  7. macro for moving information from one sheet to another
  8. VBA macro to count the occurences of two string
  9. Macro to select sheet thatīs Hidden
  10. Finding a Min and Max date for any time a name is mentioned
  11. How do you change check box font?
  12. hide sheets
  13. Clear Data
  14. how to filter in VBA from those filtered in a list
  15. Quit without saving
  16. Automation using VBA
  17. Macro Rounding
  18. How to Create this Program?
  19. conditional printing macro
  20. Macro to Copy and Insert a Varying Range
  21. spreadsheet for multiple users
  22. Line width in chart?
  23. Best way to fill user form fields
  24. Printing multiple copies of multiple sheets
  25. VBA Compare
  26. Help Port Word Macro to Excel
  27. Find & Replace
  28. retreive information from another worksheet
  29. spreadsheet to autogenerate calendar
  30. Merge (SUM) Duplicate Entries
  31. check duplicated data
  32. solution to fix excel to dbf
  33. import/export calendar info between Outlook and Excel
  34. VBA code to search all merged cells and then unmerge them filling them with values
  35. username and password login
  36. Problem with timestamp.
  37. Hide and Unhiding Columns
  38. Using Macros to monitor stock
  39. run time error 1004 in excel 2007
  40. Last in row
  41. Keep conditional formatting when selection is saved to a new file
  42. Macro for finding out all non-keyboard characters and symbols in a sheet
  43. Need to calculate the difference between different pairs of values
  44. Calling Macro From Different Workbook
  45. Highlight duplicate cells in next column...
  46. Adding more arguments to =CHOOSE function?
  47. auto update code not quite working
  48. build a udf
  49. Excel is converting .csv files
  50. macro deleting help
  51. Symbols?
  52. If cancel Application.GetOpenFilename() statement
  53. Should I buy a book?
  54. Copy, Paste, Delete and sort
  55. writing to a test file
  56. Trying to Transfer Row(s) between worksheets based on Criteria in 1 Column
  57. Managing stock in a spreadsheet
  58. Email once date reached on spreadsheet
  59. Referencing two IF statements
  60. Coding Issue Aaaargh....
  61. How do I create buttons and dropdowns in Excel?
  62. How do I write a solver, polynomial equation in Excel 2003?
  63. Excel timed automation..
  64. Clean up a line of text
  65. Writing vba conditional formating
  66. Should I delete my threads after they have been solved?
  67. How do I rename a sheet?
  68. How do you change the SaveAs file type?
  69. Convert real to string
  70. Macro Code Help with Ranges & Sheets
  71. Value of Named Range
  72. Scratching head.. email mail Function
  73. remove text before and/or after a string in a cell
  74. Conditional formatting through VBA
  75. File Browsing
  76. Convert Boolean to 0/1
  77. Help with Autofilter and Counting
  78. Simplifying the code
  79. User forms to template
  80. Extract data
  81. How to Get a Stock Price ONLY - not quote
  82. Hide calculated fields in pivottable?
  83. string = string
  84. Minimize a UserForm with no Title Bar?
  85. Opening a file using Range name
  86. Macro - Print Fit to page even with Hidden Columns ?
  87. Form Problem
  88. Help with selecting colors for a cell
  89. rearrange an aray
  90. Short date increment in VB
  91. insert copied rows with multiple criteria
  92. Web Query Question
  93. restricting cursor movement
  94. Making Inputbox text appear as *(astrix)
  95. Automatic Row Height with merged cells
  96. Running macro with No Update Window
  97. How do you .DELETE a (sub-menu) Control that was clicked?
  98. Test if subtotal exists
  99. Excel Macro to increment count
  100. Linking question
  101. Looping through several spreadsheets
  102. Need to transfer sheet + pictures to multiple computers.
  103. Importing a text file into a workbook through VB
  104. Don't know what's wrong
  105. Re-arranging column cells by value
  106. copy and paste issue
  107. vba question regarding the ability to highlight a row
  108. Color Picker
  109. OLE Depend Object
  110. Manipulating A Flat File for Import in MS Access
  111. group automation
  112. VBA code to check format of conditionally formatted cell
  113. COOL Combobox PROBLEM
  114. Data Validate a cell if Another Has certain value
  115. Excessive initial startup times
  116. Select Case and Find Combo - question
  117. VB - MultiPage vs RefEdit vs OptionButton
  118. Userform - next record button or scrollbar to navigate through records
  119. Forms: system error + error 361
  120. How to prevent overwriting of file ?
  121. Delete non-numeric entries
  122. Excel: MAcros and Locking
  123. Combobox, projector issue.
  124. Sorting code help
  125. Creating a chart from an external CSV file
  126. PERL and MACRO's
  127. Vba For Olap Pivot Table
  128. Password to Open via programming
  129. help with ftp and wildcards
  130. Need to Delete a QueryTable
  131. VBA to Sequence List
  132. Retrieve latest value different items
  133. Using Excel to Install a Font
  134. Macro for Issuing a "Work Order"
  135. Consecutive Count
  136. Opening Hytperlink - A New Twist
  137. Conditional Merge of 2 worksheets
  138. ActiveCell.Formula Error
  139. Making Multi Cells Required
  140. Paste sheet to next blank tab
  141. copy information from rows above
  142. Cutting Pipe lengths VBA program required
  143. Overflow Problem
  144. running a macro on open of workbook
  145. selecting multiple graph ranges using the cells command
  146. code to search for errors
  147. Runtime Error 13 in provided Macro
  148. formulaR1C1
  149. Dropdown selection inserts certain text
  150. Help on Transposing
  151. Open Crystal Report
  152. Find/Search for a value in one column
  153. Run procedure depending on the text of EVERY textfield in a form
  154. Searching text in cells for words
  155. practice exercise for learning VBA
  156. What is the *best* version of Excel?
  157. Mysteriously shifting print area?
  158. Formula or a macro to return the first three digits of a number
  159. Copy a Cell's contents until a blank cell.
  160. Key pressed during program running time
  161. How to change SOME of the text in a cell but not all of it.
  162. Dialog box to accept actions (no working)
  163. Moving to/Selecting the cell next to a combobox
  164. Forcing RowSource in ComboBox to increase
  165. Copy the data to the Blank Cell
  166. cases in forms
  167. If "" then email
  168. Clearing data from ranges in alternate rows
  169. adding data for time interval
  170. cant clear contents of a cell having negative values
  171. Transposing data till blank cell - Excel 2007
  172. Excel Display Options
  173. Display hyperlink text in userform textbox
  174. Numbering CurveBall
  175. Function error
  176. copying macros
  177. Sorting sheets when printing?
  178. If statement for selected cells containing comment
  179. Add Hyperlink to cell via a userform
  180. how do i add a counter
  181. copy from one sheet and append in another one
  182. Compare Inventory vs. Valid Parts Configurations
  183. Purpose of the "If Not Intersect" statement
  184. Drawn Items in Formulas?
  185. Select cell
  186. Edit Find by Macro?
  187. Option Explicit
  188. VBA question dealing with inputbox/msgbox/variables
  189. print to default printer so I don't have to open notepad
  190. formula auto adapt to change in rows
  191. Detect Constant Cell Value
  192. protect contents of cell after checking checkbox
  193. What do I need to create an Excel format file?
  194. track-changes-identify num
  195. Hover over button and change it's colour
  196. Force cell entry before move or close?
  197. Dynamic List for combobox
  198. VBA to run repeat tasks in Excel and Mainframe?
  199. assigning macros to form buttons
  200. macro scrap from excel to Attachmate
  201. Can't select cell for some reason
  202. VBA Sort Multiple Sheets
  203. Changing the focus of a cell
  204. Pivot Table Conditional Formatting
  205. match a name to a list in a range?
  206. Share a toolbar that calls macro from an add-in
  207. Change the excel Menu Color with code
  208. Drop Down Menu Options?
  209. Activating a macro when type something
  210. store sheet name
  211. code to extract specific data into specific columns
  212. Macro Combining Work Sheets Into One
  213. VBA Conditional Format Error ?
  214. Open Menu worksheet when Workbook opens
  215. Find the last row without data in columns E and F and delete the 10 rows below them
  216. import data from external files
  217. Trigger that identifies RtGet changes
  218. Sharepoint List + Excel
  219. Find Next Number in Sequence
  220. Alternative to DigDB add-in?
  221. Prevent user stopping a Movie from playing in full
  222. Page break at fixed position
  223. Saving A Sheet + Apology
  224. Copy info from sheet1 to an overview sheet with VBA
  225. How to select last five rows in the worksheet in VBA?
  226. Check where macro is in loop
  227. How to auto unhide entire book when we open the file?
  228. How to get the next empty row in a half filled Wroksheet?
  229. Advanced Filtering
  230. How to use opened Workbook as a database?
  231. Error Message - Document Not Saved
  232. Row Calculations on Variable Ranges
  233. work book links
  234. Excel Chart Viewer Slideshow
  235. Conditional Color Change Not Working
  236. sub_totaling not solution
  237. Put a custom image in a CommandBar Control?
  238. Shorten and speed up code
  239. Macro to goto appropriate worksheet
  240. data transpose
  241. GetSaveAs issues
  242. Add cells to a range variable
  243. getting heblish (Hebrew + English) text to csv or txt file
  244. "if it contains "
  245. Workbook.Open Problem ReDuex
  246. Vlookup
  247. how I can take loop counter below and send the all the incremental data to a wsht
  248. vba to automate naming cell ranges
  249. Workbooks.Open Problem
  250. Detect/find Duplicate Values In Code