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. No less then 3 of Four checkboxes selected
  2. Change characters to numbers
  3. [SOLVED] macro that deletes row before and after certain phrase
  4. Deleting blank rows using loop and SpecialCells
  5. Export Part # to excel (From Solidworks)
  6. Get cell's contents from Workbook with ADO
  7. Using macro to sort and move information
  8. [SOLVED] How do I refer to the last row in a selected area using VBA?
  9. [SOLVED] Open different files with 1 button
  10. [SOLVED] Call cell from other workbook
  11. Macro to call another macro
  12. Using VB script to send keystrokes to another program
  13. [SOLVED] How to end a FindNext Loop
  14. [SOLVED] Range Selection and Origination Difficulty
  15. Prevent Sheet Deletion
  16. sorting two columns
  17. [SOLVED] Retaining ListBox Text Formatting
  18. moving specific cells only
  19. Custom Function based on cell text color
  20. need to pull data from changeable appended tabs
  21. [SOLVED] For Each causes a "subscript out of range" error
  22. Macro to Delete Rows
  23. [SOLVED] Worksheet Pop- up box
  24. Merging content in columns using macro
  25. [SOLVED] More than two criterias in autofilter
  26. Attendance calculation, Excel Macro
  27. VBA Project locked
  28. VBA Password cracker
  29. Macro to check data from 2 columns and highlight data
  30. Macro to import a sheet from another XLS file
  31. [SOLVED] [Solved]Copy, New file, and Email
  32. Short circuiting logical expressions?
  33. Insert rows and autofill formulas
  34. Help required for a tricky problem(s)
  35. Date, Cell Selection and Print Macro - Possible?
  36. Shared workbook overwriting
  37. [SOLVED] Copy data in multiple sheets and paste into one sheet.
  38. sending email alerts
  39. Moving between Forms with CommandButton
  40. [SOLVED] VBA - Putting a border around cells that arent empty
  41. Runtime Error '9'
  42. User Forms & Setting Focus
  43. Excel+C# Auto Format
  44. help edit code due to 2003 column limit...
  45. [SOLVED] Copy data from Excel into Excel
  46. [SOLVED] VBA Spell Check - Dont ask to check rest of Doc?
  47. [SOLVED] Run-time erro '445' : Object doesn't support this action
  48. [SOLVED] If-then to check cell's value
  49. Moving between Forms
  50. Export mySql to Excel
  51. find the blank cell in range and replace it
  52. [SOLVED] Getting the old value ????
  53. [SOLVED] Specify Column Range
  54. [SOLVED] Worksheet_Change event not firing
  55. [SOLVED] AddTextBox
  56. Automatic Change of Range
  57. [SOLVED] testing a selection
  58. Auot insert value in a column - cross-post
  59. [SOLVED] Dynamic range vba coding
  60. Referencing controls on custom menus
  61. Giving Bulk Data feed Using Excel
  62. [SOLVED] Macro to search column for blank cells & shift entire row right
  63. How to add negative records in a macro
  64. [SOLVED] interupt code for user input
  65. Calling subroutines
  66. [SOLVED] deleting selected pictures
  67. Displaying column header text in other cells
  68. Creating Random numbers in Excel problem
  69. backing up a separate instance of a workbook
  70. myfile.readall (exceeding max)
  71. [SOLVED] Screen updating & icolor
  72. [SOLVED] Auto insert value in a column
  73. [SOLVED] Floating textbox ?
  74. Method 'ReadAll' of object 'ITextStream' failed
  75. Highlight cell
  76. [SOLVED] Open different workbook in different path at the listbox
  77. Inserted Cells are removed from sheet protection range
  78. Display only the choosen plots
  79. [SOLVED] Define Name to current selection
  80. Hyperlinking
  81. Delete extra rows using VBA
  82. [SOLVED] Troubleshooting code for export to text file.
  83. [SOLVED] Perform same task on all sheets in a workbook
  84. [SOLVED] Selecting a range of cells with R1C1 notation
  85. [SOLVED] Turn Off Error Messages While Typing Code
  86. Code to lock a cell after data entry
  87. adding and subtracting 1.54 hrs
  88. add to a range using a form
  89. Protect registry through VBA
  90. Interesting and Challenging Sorting and Matching Problem
  91. Allowing different ranges to be chosen
  92. [SOLVED] Problems with selecting a segmented range
  93. filling in empty columns
  94. [SOLVED] Getting error while trying to send email thru MS outlook 2007
  95. Named Range that Alternates Rows?
  96. Create add new record macro in a sheet
  97. Combine Columns Leaving Only Duplicates
  98. [SOLVED] Refer Folder/Filename in VBA code through Named cell reference
  99. [SOLVED] Rows insert
  100. conditional formating based on change in same cell
  101. Changing Cell Values In VBA
  102. [SOLVED] Find Birthday of persons which falls between the given two dates
  103. [SOLVED] User input for current path?
  104. Visual Basic for copy and paste columns
  105. Referencing workbooks
  106. Email Status of a Job as it changes
  107. [SOLVED] Copy data from one file to another with different no of headings
  108. inserting lines and formula macro
  109. [SOLVED] Populating a grid from various excel reports
  110. Make paragraphs in body of outlook task created from Excel
  111. VBA to add leading o's and trailing space for fixed length SIR fields
  112. selecting only data containing part of sheet
  113. Cell content FLOAT ?
  114. Do while loop sorting data
  115. Send Parameter Into Macro
  116. Macro to Save file with date/time stamp
  117. [SOLVED] Option Button Help
  118. [SOLVED] Excel Macro referencing a variable file name to import
  119. Renaming files from column data
  120. Get closing stock prices from outside data source
  121. Data matching from 2 large data sets
  122. [SOLVED] Choosing data from defined work source range
  123. [SOLVED] How to automate export for a range of cells to text file
  124. Conditional Formatting & Character Count Comparison Macro
  125. Copying Excel into a new word file with macros
  126. Auto fill the column
  127. [SOLVED] Hyperlinks and blank cells
  128. [SOLVED] Changing Button Attributes in VBA
  129. [SOLVED] Importing a partial text file
  130. Opening a file automatically to refresh links
  131. [SOLVED] Replace - at end with - at beginning
  132. Update Information from a file
  133. Conditional formatting using a macro.
  134. Macro dosn't work next day
  135. [SOLVED] Spell check on a FORM
  136. Selecting Files from workbook
  137. [SOLVED] Copy and rename based from list
  138. Message box - How to add a carriage return
  139. Sending NOT excel file as an attachment via Excel
  140. Checking a check box that checks other boxes on other sheets
  141. macro creating email using outlook express
  142. [SOLVED] Email from Excel file
  143. Compare worksheet columns and highlite differences
  144. Copy entire row from one sheet to another base on answer
  145. [SOLVED] Minimize UserForm (Attn: Leith Ross)
  146. [SOLVED] Auto call a procedure by selecting from a dropdown list
  147. [SOLVED] Why is this code creating a new page?
  148. Existing macro not found
  149. merge workbooks
  150. Is "top" a special name or variable in VBA?
  151. Using VBA to copy and name a worksheet
  152. Conditional Formatting Using a Macro
  153. Calculating total shift hours in a schedule
  154. Selecting a file from workbook
  155. Can excel send automatic email to outlook
  156. Should I use an IF statement?
  157. Is there a macro for copying and pasting data..
  158. VBA for Summing same cells in multiple worksheets
  159. If Statment conditions
  160. [SOLVED] set as workbook
  161. [SOLVED] Looping Through and Processing 1000 records at a time.
  162. Insert new row and add formula to a cell
  163. every 5 sec
  164. Macro for the adding new row with the data
  165. [SOLVED] Drop Down List isn't transferring in new row
  166. [SOLVED] Auto Date Stamp Help in Multiple Cells
  167. Circular Reference
  168. [SOLVED] Audio alert
  169. "Subscript out of range" error message when using HPageBreaks.Location
  170. [SOLVED] Returning a value
  171. Paste sheet into already existing WB
  172. Taking data from sheet 3 and auto entering it useing a keyword to sheet 1
  173. Date Range Macro?
  174. [SOLVED] Inserting Page Breaks on relative Rows based on Data
  175. How do I display an error message if Find Macro is unsuccessful
  176. How to Activate a Sheet from a ComboBox
  177. [SOLVED] Add Text from specific cell to next empty cell in a column
  178. [SOLVED] declaring a variable with leading zero's
  179. Change GetOpenFilename Default Location
  180. FileNames: How do I Distinguish Between Multiple Versions Open of Similar File
  181. copying cells using vba
  182. ChDir & ChDrive problem
  183. Stop now function auto updating when new row added
  184. Opening on same sheet
  185. Using an If...Then statement
  186. [SOLVED] VBA expression to insert pagebreak
  187. [SOLVED] Populating from one sheet to another, by Date
  188. Force Paste Values
  189. [SOLVED] VB Code/Macro Printing with Page End pulled from Workbook
  190. Excel 2007 / 2003 difference in protected mode
  191. Log Access/amendments to document
  192. Creating a Pivot Table using VBA
  193. [SOLVED] Userform textbox code
  194. Object Editing under protection
  195. Recalculating functions when an array is updated
  196. Update macro
  197. [SOLVED] Difference Between Range and Range.Value
  198. showing updated weather
  199. [SOLVED] hide/show multiple sheets by macro ?
  200. how to read the name as a text of a selectable file?
  201. Problem with separator or )
  202. Sending data from Excel to SQL Server
  203. VBA Code not Matching an inputted Date to Generated Calender
  204. [SOLVED] Not sending data from Form to Sheet
  205. Advance to new month macro???
  206. [SOLVED] Find newest file in a folder
  207. Automatically creating tabs and entering values/formulas
  208. [SOLVED] VBA Error: End IF without Block IF
  209. [SOLVED] Object Required
  210. [SOLVED] Error in range search code
  211. Form table of contents for a sheet
  212. [SOLVED] Macro which picks out dates and the data relating to them
  213. How to Keep headers while merging worksheets into master list
  214. Cell update
  215. [SOLVED] Formatting Cell Colors with Multiple Conditions
  216. continue code
  217. Using a Hyperlink to send email
  218. Explain the use of ModelClass use in the attached code
  219. How to shorten the code?
  220. Run-time error 1004 - Application-defined or object-defined error
  221. [SOLVED] Anyone Know the Best Way - Preventing Users from doing this...
  222. [SOLVED] Copy worksheet from one workbook to another
  223. macro for saving multiple instances of an xls in multiple formats.
  224. Macro for Highlighting Rows based on Cell Value
  225. Conditional Formatting More Than 3 Conditions
  226. Macro advancing to new month
  227. Cut and Paste Macro
  228. Best way to code a repeatedly used array?
  229. [SOLVED] Which are the variables in the code?
  230. Auto fill up column and protect the column
  231. [SOLVED] 'Select method' failure
  232. Copy Non Contiguous cells
  233. sum only visible cells
  234. [SOLVED] VBA--Does a File Exist
  235. [SOLVED] Decimal To Fraction (Inches)
  236. Double prompt to save on closing
  237. Select Duplicate Account numbers and move to new sheet
  238. [SOLVED] Importing very large text files
  239. VBA Goal Seek
  240. [SOLVED] Loop through all Sheets, PasteValues
  241. [SOLVED] Day and Date in UserForm
  242. Emailing file with latest date
  243. Combine matching data
  244. Percentage Complete
  245. VBA Deleting data until empty cell
  246. To run a macro when values of the cells modified?
  247. VBA Hiding rows
  248. [SOLVED] Set Worksheet button properties
  249. [SOLVED] Passing Info from a Form combobox
  250. moving data