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. Deleting rows/columns depending on text value, and joining of data from several colum
  2. inserting rows
  3. Conditional Formatting two rows and then copying
  4. [SOLVED] finding cell using "Left"
  5. [SOLVED] VBA WorkBook_BeforeSave and Protection
  6. Auto Hide column
  7. Date and Time Program
  8. [SOLVED] Userform Questions
  9. [SOLVED] find column that has value and put formula in cell
  10. Find last instance of a word and insert blank row
  11. [SOLVED] Writing a macro that deletes blank rows
  12. User input used in macro
  13. Installing Calendar Control 11.0
  14. ChangeLink with remote file
  15. Form to add to a defined name
  16. login error
  17. [SOLVED] To copy and paste two columns from a worksheet to another worksheet simultaneously
  18. [SOLVED] Automating the Number of copies to print based on a range
  19. initialize comboboxes value list during sheet activation
  20. Send Specific Data to New Spreadsheet by Pressing Button
  21. Cant do it without VBA
  22. [SOLVED] Using with statement to reference two sheets
  23. [SOLVED] Override VLOOKUP In UserForm
  24. [SOLVED] Filename = Cell Contents
  25. [SOLVED] Using VLOOKUP In A UserForm
  26. Matching rows from different sheets
  27. More than 3 formatting conditions - select case?
  28. Macro - autocolor on entry
  29. [SOLVED] How to select a dynamic (?) range?
  30. Pivot Tables, Macro Related
  31. Create Pivot
  32. check if sheet is empty
  33. Macro to (i) drag and drop & (ii) input array formula
  34. Outlook Mailbox Recieved Total
  35. how to pass array values to function
  36. [SOLVED] Mouse Focus Changes After Script Runs
  37. naming worksheets
  38. Formula cell referencing problem
  39. Dynamic Cross Referencing
  40. Dynamic Page Break: Column Widths
  41. Updating Chart Titles
  42. collect information from many workbooks using filters
  43. [SOLVED] Copy and paste to a different sheet
  44. Conditional Cell Color Change For Multiple Cells
  45. Footer Macro
  46. transferring data from old to new revisions
  47. Loop while data exists
  48. [SOLVED] Clicking Red X on UserForm produces run-time error '91'
  49. Getting error 1004 on this code why?
  50. Macro to Paste Special Values, Remove Sheets and Save
  51. Not sorting correctly
  52. [SOLVED] VBA Password Crack/Hack - How easy is it?
  53. finding impossible to save sheet 1 to pdf to desktop
  54. Macro Help
  55. Looping Thru Cells in a Discontiguous Range
  56. Copying Sheet
  57. [SOLVED] Error on FindNext Method
  58. Macro for huge input/output problem using relative reference?
  59. Search sheet and display results
  60. Find and copy problem
  61. [SOLVED] VBA to change a particular cell version 2
  62. Problems with custom sort order
  63. Tsp
  64. Form to add to a defined name
  65. Trying to grab value of cell above using Offset
  66. [SOLVED] name a textbox without selecting it
  67. Macro Security
  68. [SOLVED] Exit sub from user form problem...
  69. open a file in VBA
  70. How to diasable a cell based on listbox value on another cell?
  71. Macro for Word in Excel
  72. VBA for comparing dates within conditional formatting?
  73. amortization table,method 'range' of object _global' failed problem
  74. [SOLVED] locking column a only
  75. Sort but ignore cells with ""
  76. VBA array
  77. [SOLVED] Calculating Formulas + relitive cell ref
  78. Macro - Calendar
  79. [SOLVED] Inserting ">","<" etc. in a formula
  80. Change case to range of cells
  81. Copy To New Sheet With Conditions From Another Sheet
  82. [SOLVED] need page break by asking the input file for page break to be done
  83. [SOLVED] modify macro to give myfilename ddmmyy_hhmmss
  84. File Search Consolidation
  85. [SOLVED] How to Change an Input Box based on input in another
  86. How to test the entire row if it is empty or null?
  87. [SOLVED] text to columns macro..ignoring warning box
  88. Select case
  89. Need some assistance
  90. [SOLVED] Save average() of a variable selection to a variable
  91. [SOLVED] Help with LOOP!
  92. Sorting Macro
  93. With Sheets
  94. UDF not working properly
  95. Hiding Check Boxes In VB excel 2007.
  96. Change to Array to make more efficent
  97. turning ranges red, amber or green
  98. [SOLVED] Format Method - how do I stop a cell turning into a date?
  99. [SOLVED] adding cell = macro not working
  100. If then Else with a Macro
  101. save one sheet to specific folder but not second sheet
  102. [SOLVED] Adding Columns and Formulas
  103. Send results of SQL query to an array
  104. AutoFilter macro with dynamic criteria
  105. Need help with what I would think is easy vb code
  106. Need help updating Pivot table
  107. [Solved] Macro to fill data
  108. Syntax Help To Run application in other workbook
  109. [SOLVED] Remove Underscores
  110. populate a listbox
  111. Excel and external VBA
  112. [SOLVED] Creating Tab Rows
  113. copy vba code from 1 workbook on to another by use of vba
  114. USER/LOGIN to different sheets
  115. [SOLVED] Adding Time Function
  116. manipulate and view information in excel 2007, from VBA6.0
  117. xlsm macros from pc to Mac HELP
  118. Moving Ranking formula
  119. Problem identifying range
  120. lock cells in a book with VBA code
  121. [SOLVED] Copy data from another workbook and paste the data from according to the column title
  122. [SOLVED] Else Without IF Error Message
  123. [SOLVED] how do i remove focus from form?
  124. Improvising the Macro
  125. simplify enclosed codes in several forums
  126. [SOLVED] Macro Pop-Up Box
  127. [SOLVED] How to create worksheet Interfaces?
  128. [SOLVED] excel vba menubar .Onaction cannot be found
  129. Programable buttons in work sheets for excel 2007?
  130. Help with deleting rows in VBA
  131. Random colon delimitation help - Remove colon delimiter?
  132. Saving textbox values to another workbook
  133. [SOLVED] Do... Loop macro problem
  134. Macro to reset drop-down to first value
  135. [SOLVED] Multiplication table - really cool one
  136. Changing Code To Modify Entire Workbook
  137. loading today's date into a cell from a macro
  138. Accessing DLL in VBA 2003
  139. Seaching for a String within a cell
  140. [SOLVED] Alternative to the FileCopy Statement for open files?
  141. [SOLVED] conditional shape
  142. code to protect formulas
  143. [SOLVED] saving file in a macro
  144. Range.Offset limit in Excel 2007?
  145. opening files in a loop with "1" or "10" in the name
  146. Makro with two different Excel sessions
  147. [SOLVED] Assign ListBox by code
  148. Array being cleared/reset on error?
  149. [SOLVED] Dynamic Find and Replace
  150. Loop for all Worksheets
  151. Excel 2003 - Disable entire user interface
  152. Convert VBA to VB6...
  153. Extracting Macros and VBA Code from an Excel
  154. Macro to give finished date and time of work
  155. [SOLVED] Spinbutton to cyle backwards/forwards on Multipage Userform?
  156. VB Macro to compare data
  157. Copy Selection to "New" worksheet
  158. Cpying Unique entries to new spreadsheet
  159. [SOLVED] Problem with Vlookup macro - Run Time Error '1004'
  160. Paste Excel Table in Mail using macro
  161. [SOLVED] Need to have multiple page break.
  162. [SOLVED] Password protection for a macro button
  163. [SOLVED] Assistance with Creating a Specific Macro using VBA code
  164. Filecopying, filename as excel list.
  165. Code for removing "." (dot) in SH_Code
  166. Auto Fill Web Form using Excel User Form
  167. Batch File Script
  168. SQL Macro
  169. Change ByVal Macro Question
  170. [SOLVED] Business Week Start Date
  171. Strange ScrollBar behaviour
  172. [SOLVED] Defining a Variable as New Collection
  173. [SOLVED] A variable which is used by several subs in a worksheet but is not global?
  174. macros running sloowly. excessive file size
  175. Populating a texbox with the date
  176. [SOLVED] Remove duplication and sort a string
  177. [SOLVED] how to sort rows according to a variable
  178. [SOLVED] Number to String
  179. Column should be Change Automatically with change in Month
  180. [SOLVED] Autocreate Tabs and insert Formula Problem
  181. [SOLVED] assigning variables in consecutive order
  182. Convert xml to csv
  183. [SOLVED] where did my macro go?
  184. Auto Poplulate data
  185. [SOLVED] Activate Sheet and Disable Tabs on Open
  186. [SOLVED] hidden sheet appears by ticking a check box?
  187. Sum 2 Rows into one cell
  188. Sum of rows in 7 columns
  189. [SOLVED] Adding to excel workbook
  190. Protecting Data Validation Using VBA
  191. Pop up a message box based on values of a range
  192. SQL query from Excel table
  193. Update Database
  194. [SOLVED] End If Problem
  195. Find method and data types
  196. Finding & clicking on a specific webpage hyperlink
  197. [SOLVED] Date Issue VBA
  198. Autofilter Problems
  199. Creating an embeded line graph
  200. [SOLVED] Close and save application
  201. [SOLVED] Open to a particular page
  202. VBA Vlookup
  203. Enabling and disabling buttons depending on amount of worksheets.
  204. [SOLVED] Remove the "Close X"
  205. [SOLVED] How to Keep a Function Private but Available at Different Levels?
  206. [SOLVED] Activate the cell after the last used cell
  207. [SOLVED] Date formats in a shape
  208. [SOLVED] How do I Trigger a Macro on Workbook Close?
  209. using CALL to call methods mandatory?
  210. Assigning Macro to shape in 2007 - Crash!
  211. [SOLVED] Move cells on same row
  212. [SOLVED] Look for value in row and copy cell value 13 rows below
  213. [SOLVED] filling a userform combobox
  214. Outlook confirmation message while esnding email via VBA
  215. [SOLVED] copy number from 900+ workbooks
  216. If A1 is not blank, then delete info in cell B1. How?
  217. [SOLVED] Decimal Place in Number
  218. [SOLVED] QueryTable question
  219. [SOLVED] Trying to get a loop started
  220. [SOLVED] Auto save and close workbook after user defined length of idle time
  221. Using VBA with Hidden worksheets or protected worksheets
  222. I want my worksheet to use Banker's Rounding
  223. 2 Command Button VBA Project
  224. Close a new workbook
  225. Advanced Filter Macro With Field Not Blank
  226. Logical Functions to Output a Value
  227. [SOLVED] Using String Manipulation to create and change wroksheet name.
  228. [SOLVED] Code For Advanced Filter Function
  229. Automatic Updating from Multiple Files
  230. [SOLVED] copying sheet is truncating data
  231. Run-time error '1004' - Please translate
  232. Extract Data from all spreadsheets in a certain folder
  233. Keeping a cells date when it's condition expires
  234. [SOLVED] Select rows depending on selection
  235. VBA or Formula
  236. [SOLVED] Paste special as values code not working?
  237. VBA On InsertRow
  238. Extracting data from a spreadsheet
  239. Barcode Help
  240. [SOLVED] Check if columns are grouped (VBA)
  241. Controlling Excel from Word
  242. [SOLVED] Insert single blank row between multi-sheet paste process
  243. Performance issues, program lags before executing
  244. VBA - Adding Formula to a cell
  245. [SOLVED] Moving Standard deviation
  246. How Do I Copy Several Sheets into New Workbooks
  247. Data Extract from Multiple Workbooks.
  248. [SOLVED] setting background colour
  249. Run-time error '1004'
  250. Rounding up to desired decimal value