PDA

View Full Version : Excel Help



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

  1. Calling a Worksheet_SelectionChange Subroutine
  2. Adding Date to File name
  3. Solved: Need a replacement for sub underneath sub
  4. Solved: Data Validation Error
  5. help speed vba code
  6. Loop problem
  7. [SOLVED] IF Statement
  8. Solved: VLOOKUP as a sum
  9. Help:How to identify the sheet number of the first sheet?
  10. Solved: Scroll Bar Length
  11. Excel 2007 and Conditional formatting
  12. Solved: Excel 2000 commandbar question
  13. VBA LogParser and Yahoo RSS feeds
  14. Issue about size in excel
  15. Solved: Position Values on Stack Bar chart
  16. what is wrong with this code?
  17. Array manipulation
  18. Solved: set reference to Windows Script Host Object Model ???
  19. Help with Index Custom Function
  20. Solved: Count Total Columns used in Sheet
  21. Inserting worksheets automatically in the same workbook..Guidance reqd
  22. Cutting a loop short...
  23. Code modification for updating
  24. Empty Cell Reference
  25. How to transfer the data from other Workbooks to my worksheets in this case
  26. Dynamic toolbar fails under certain condition
  27. Help:User interaction when code running
  28. Solved: excel 2007 saving to 97-2003 compatible
  29. Suggestions please.....
  30. code for review - Excel "new window" substitute
  31. Deleting identical rows between sheets?
  32. Solved: help: How to get cells data for calculation in the best way
  33. Wraptext
  34. How to set Iteration Times in Solver with macro
  35. Log-in server time
  36. Excel
  37. Cannot copy a range....
  38. SUMIF question
  39. Solved: month end reminder
  40. Completely remove form from Excel file
  41. Solved: Conditional format
  42. Solved: WEEK DAY REMINDER
  43. restore excel to default
  44. Make directory at Network Login name
  45. Solved: File Search in Excel - hidden files?
  46. Solved: Combo Box: set possible values 1 thru N in code
  47. COMBO BOX question
  48. Solved: Rename object and code
  49. Solved: Save data to notepad file and leave link in worksheet
  50. Incrementing the previous value
  51. Solved: Pop up data in Excel
  52. Find Local Time
  53. Vlookup help
  54. Solved: Printing multiple pages based on cell
  55. Calculation by VBA
  56. Solved: Opening a window to the active.path location
  57. Time Elapsed
  58. Solved: Show remaining time
  59. Solved: A "Browse" option for File Save?
  60. Solved: Define constant path
  61. Can't Populate Recordset due to SQL code
  62. Solved: Deleting a part from a parts list with a macro
  63. Solved: Upper, Proper, and Date Formats
  64. Solved: Using a String to Run a Macro
  65. Userform Treeview
  66. Solved: Getting Page Count for a Workbook
  67. Solved: compare worksheets
  68. Solved: Variable type question
  69. Solved: Conditional searching using VBA
  70. Searching Cells for String
  71. Solved: Excel Code Efficiency with DB Connection
  72. Solved: Download file from web
  73. Solved: A Simple(?) ComboBox Query
  74. Referencing Cells in changing worksheets
  75. VBA Find and replace in XML/Text file
  76. Solved: Casting to Text
  77. [SOLVED] Copy to OPEN Workbook, not named...
  78. How to get the data from the "Staff Record.xls" in VBA
  79. Substitute variable into a range
  80. Football Cup maker
  81. Solved: ComboBox & Dynamic Arrays
  82. defining a data source as a variable
  83. Solved: Selecting a Cell on a worksheet.
  84. Solved: Import by tab name
  85. Column Sorting
  86. removing duplicates
  87. Solved: Hide column on selection change
  88. Using spinner in a protected sheet
  89. How to change sheet name at close excel workbook
  90. VBA Help in books
  91. Disabling the "Unsafe ActiveX controls" promt in excel
  92. Help:Just some clarification...
  93. print multiple sheets based on user choices
  94. Last Date Used:
  95. Solved: Help with array formula
  96. Row and Column Numbers in VBA
  97. Solved: Question on sheet names and Copy
  98. Find Method To Find 2nd Occurence
  99. Solved: word wrap or new line
  100. Prevent VBA generated charts from refreshing
  101. Hide rows based on cell in row
  102. Publish Selection to Web
  103. CellColor Macro Not Working
  104. Solved: "Tagging" a Cell
  105. Solved: Paste Special,Text question
  106. Auditing in Excel
  107. Newbie help: advanced table manipulation
  108. Seek help to highlight number.
  109. Solved: Looping required
  110. Calculations between Textbox values on Form
  111. Macro - Pivot Tables
  112. Union Query in VBA
  113. Solved: clear cells if, like reset
  114. Searching a range
  115. Show sheet based on serial number
  116. Need help setting tab orders
  117. Solved: Sloved:Why GetOpenFilename not working
  118. 180 Day Calendar
  119. Excel Lists
  120. Create Summary Sheet
  121. Hide Rows based if column I = 0, then set print area from row 80 to everything visibl
  122. Solved: Data Validation Code To Force Prior Cell Entry
  123. Row entry without keeping any row blank
  124. Solved: Copying Workbooks without disrupting the original
  125. Solved: Prompt to save on close (askes if already saved?)
  126. Creating charts automaticaly in Excel
  127. Solved: Excel 2007 ExportAsFixedFormat
  128. Version clash
  129. Solved: Message box Format??
  130. Solved: removing spaces
  131. Solved: Amend cell in row based on value in first cell
  132. Multi-Delete Function Problem in ListBox1
  133. delete rows based upon external list
  134. inporting external data
  135. VBA to EXE
  136. Solved: Remove Formula
  137. Transfer the data from the multiple files into 1 worksheets
  138. Solved: Hyperlink Address
  139. Extract Text
  140. Loop Comparison Theory Discussion: For.Nxt vs. For Each
  141. Diaplay text in a cell
  142. Making URLS Hyperlinks
  143. vlookup worksheet formula error: sub or function not defined?
  144. Solved: Conditional formatting
  145. I want to change the color of some letters, but it does't work
  146. Playing w/ Arrays
  147. Counting Multiple Criteria
  148. Problem of open all file(s) in the listbox
  149. Print Setup via VBA
  150. Solved: delete columns with an array collection
  151. Problem in the Range Row index
  152. Solved: IsError Function
  153. VBA obfuscate data & find cell
  154. Solved: Populate Column based on contents of range
  155. Solved: Help with Lookup Function
  156. Adding sheets to summary
  157. [SOLVED] Automatic close and save
  158. Dummy post so I can creat4e an attachement
  159. Sort data and past into new sheet
  160. Problem using arbitrary column length in a user defined function
  161. Solved: populate combobox problem
  162. Dynamic Plotting
  163. Solved: Linking Again?
  164. How to Give Upper & Lower Limits to a Plot?
  165. Solved: Delete duplicated rows
  166. Solved: Migrating frm Excel 2003 to 2007
  167. Solved: Nomenclature for referencing named cells in .Formula Code
  168. Solved: Prohibit or restrict copy
  169. Solved: Populate UserForm TextBox based on Worksheet Lookup
  170. Problems in calculation of Means, Max, Min in VBA
  171. Solved: Extract number of digits/characters of a variable
  172. Sorting producing wrong result
  173. Solved: Is there a way to have code trigger an event when trying to save or print?
  174. Macro on Window Activation
  175. ASCii code to allow a space
  176. Opening an Access Form via Excel
  177. Solved: Search for Missing Module/Code?
  178. For-Next Loop Help
  179. Disabling worning message while closing a workbook.
  180. Solved: Tool to check VBA code
  181. Solved: Cannot Open The Excel File
  182. Solved: How to copy data from one sheet to another
  183. Solved: Activate sheet after add/sort sheet executed
  184. Solved: Change event in range selection
  185. Solved: More than 1 Validation in Single cell
  186. Delete duplicated rows 2
  187. Solved: Two instances of the same form?
  188. Solved: explain formula
  189. Compare 4 worksheets in a workbook
  190. Solved: Difference between UDF & sub routine
  191. Solved: Help w/ Summing Range
  192. Solved: Onchange event to check a date
  193. Possible 1-liner
  194. Solved: Working with visible rows
  195. How to identify non-whole number?
  196. Find all instances of a word and return the results in a userfrom - not working
  197. Solved: Open a workbook & copy data using
  198. Solved: truncate and add two text boxes into third
  199. prevent minimize window
  200. Target Line on Plots
  201. Changes formula to value- wrong number format
  202. including string in string
  203. If your search string isn't found...
  204. Copying from a Dynamic Source!
  205. Don't show the opening/closing workbooks
  206. Instring Replace: Error
  207. Solved: Copy Paste using macro involving 6 different workbooks
  208. Solved: Workbook_SheetSelectionChange Event
  209. Solved: Highlight Duplicates
  210. Goto nested if's
  211. Help: How to change color pallet?
  212. Cell formula question
  213. Change properties of a Combobox
  214. Monitor the Caps Lock Key
  215. Solved: two routines under one event, but they don't work?
  216. Drag & Drop TreeView
  217. Calling multiple sub procedures fails after 1st Sub!
  218. Solved: Calendar value to form
  219. Solved: Loop through controls on userform
  220. Solved: Delete Rows-However keep the first found Row
  221. Watch Window to jump to cell?
  222. Question for the file(s) in the listbox
  223. Page subtotal macro combine
  224. Appel = 10 in Excel spread sheet?
  225. How to creat Dynamic Text box in term of size
  226. InputBox Auto-Complete Function
  227. VBA module's name.
  228. Populate URL address using VBA
  229. Solved: Prevent User from moving userform
  230. Solved: Filtering Values and splitting worksheet according to the values
  231. Distinguish the xlup and xldown
  232. Putting A Date Into A Cell
  233. Data Validation
  234. Solved: use formula in VBA for vlookup
  235. Solved: Textbox always displays end instead of start
  236. Fixing Numbers
  237. Which method: Vlookup, InStr, Other?
  238. data and dates
  239. check cells content before executes macro
  240. Watches Window: View what row active?
  241. Call Stack overflow
  242. Solved: Consolidation macro
  243. Solved: Last Used Cell
  244. Excel sending data to Several E-mails
  245. Solved: Msg Box to appear once on opening a WB
  246. Moving data in sequential order
  247. automatic run module
  248. Solved: Delete Certain Columns
  249. Autofilter Field
  250. Code help: dialogue box to add a toolbar