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