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

  1. deletea ll sheets
  2. Solved: Excel to get Data from an Access Database
  3. fifa 2006
  4. Solved: Active Workbook
  5. Find the last item and select it
  6. Solved: subtract time
  7. Solved: Indirect Vlookup vba
  8. Moving Items Between ListBoxes
  9. Conditional Formatting cells containing certain (amongst other) values
  10. Solved: Summing variable ranges
  11. Copy content from excel to word.
  12. Macro to Edit Workbook Links
  13. Solved: Deleting worksheets
  14. Solved: Class With Events
  15. macro from one workbook updates another
  16. Worksheet name as a variable
  17. getObject disable update links or choose don't update
  18. Controlling Defined Name Scope
  19. Solved: Count Text
  20. Determine which strings are new and copy them to WS
  21. Copy worksheet information to Word using VBA in Microsoft Excel
  22. Solved: Check whether row is odd or even
  23. Solved: Can't see Reference as object
  24. Calculating Duration
  25. Excel Version problem??
  26. Find Method and WholeWord in Excel
  27. Automatic Add/Delete Rows or Columns
  28. Solved: Find Method - Why & How?
  29. How to change the target of the hyperlinks in excel VBA ??
  30. Solved: ActivePrinter
  31. Solved: Create a new word doc for every worksheet?
  32. RefEdit
  33. Solved: How do I do preformatting in excel and copy that formatting + data over to word?
  34. Copying specific records from specific date period
  35. Solved: Converting Excel Sheet into PDF
  36. Solved: Design Advice & VBA Usage
  37. Solved: Delete rows by dates
  38. Solved: How do you name an imported module via code?
  39. Solved: How do I get the VBA Extensibility library?
  40. Solved: Filtering out cell contents
  41. Alter The Name When Saving
  42. Solved: Autofilter's Strengths And Weaknesses..
  43. ABOUT SAVE
  44. limited times or dates usage
  45. Change cell colour and copy cell format over to word
  46. Personal workbook?
  47. Solved: Sum If funtion help
  48. why i dont get 100% correct results
  49. Solved: Log Excel Worksheet Activities
  50. Solved: When cell is selected need to change color/highlight the row and columns
  51. Solved: Help With Hiding Colums
  52. Solved: After a macro or code is run the undo function doesn't work.
  53. Solved: Excel Templates
  54. Solved: help,about use 2 vba at the same time
  55. help ps, run out time
  56. Solved: Compare text strings in macro with strings in WS
  57. Solved: Find last used cell, then insert new row & paste data from other worksheet
  58. Move chart from one sheet to a specific location on another sheet
  59. Sum If/ Data output problems
  60. Solved: check entire cell for a word
  61. Macro - please help with VB Code
  62. Solved: Excel to Word mailmerge problem
  63. Solved: How to Access Objects/Tools (ie ListBoxes) of a UserForm?
  64. Change the position and size of the Pie Chart
  65. Copying & pasting with a For...Next Loop
  66. Solved: Help w/auto "Save As" macro
  67. Concantenate Loop
  68. 2 Files
  69. Solved: Merge Rows Problem
  70. How to format fonts in VBA?
  71. Solved: Hiding and showing a chart with a cmd btn
  72. Looping
  73. create a sequal
  74. Solved: consolidating columns
  75. Can you reference an enum value as a string
  76. How to determine #/type of function arguments via CODE
  77. Can we write both in left and right alignment in same cell?
  78. Convert Macro to VBA
  79. Friday discussion - Monty Hall
  80. How do I use createsummary?
  81. Solved: Auto - Filter (check on/off Status)
  82. Solved: Problem Deleting Rows
  83. Sort A to G and S columns
  84. Advice on Good Programming Books
  85. Get Row Count after Filters have been Set
  86. Switch to second worksheet or add new one
  87. Solved: Trimming Things Down...
  88. Solved: Numbering by date
  89. Solved: sending email to Outlook with ClickYes
  90. internal order of sheets, CodeName
  91. Solved: Adding Rows in Userform
  92. Solved: Worksheet naming based on cell data
  93. gmt function
  94. Calculate future date w/ out weekends and holidays
  95. Solved: UserStatus,GetObject and Application UserName
  96. Auto open procedure via vbscript
  97. Lost links to shortcuts
  98. Solved: Looping Creation of Pivot Table
  99. Frustrated trying to Reorganize Dataset
  100. Solved: help with this VBA
  101. Fun - Ask user if they want to edit (on a timer) before running workbook_open
  102. Sumproduct syntax as a VBA Worksheet Function
  103. Solved: How do you Redim Preserve a 2 dimensional array?
  104. Doing a date out(radio button)twice where i want the 2nd time not allowed to
  105. Shared Spreadsheet
  106. how to copy and paste a row of cells from one worksheets to another worksheets?
  107. Solved: Opening workbooks within subfolders
  108. Unhide Rows
  109. Solved: Problem of accessibility within a project
  110. Solved: Assistance Reducing to Better Code
  111. Graphic problem when I print an excel file into PDF
  112. Solved: Data won't copy to database
  113. Solved: dynamic name Rage? (or better solution)
  114. Solved: Integral cells as header
  115. Solved: disabling insert / delete command in excel
  116. Solved: xlPasteSpecial method
  117. Solved: Help adding a couple lines of code
  118. Solved: Border Trouble!
  119. Copying 2nd Worksheet Below Existing Data
  120. Solved: Find value in column
  121. Solved: Posting w/ HTML?
  122. Solved: Insert wb2 filename into wb1 cell
  123. Solved: Multiple selections
  124. Solved: Code example required please?
  125. FilterData & Copy
  126. Solved: At each change find lowest two and copy
  127. Solved: Find Value in Column
  128. Neep help speeding up some code
  129. Error while populating a combobox from Access database
  130. Refresh PivotChart excel freezes
  131. Count number of times each injury occurs in the current month
  132. Solved: Summarise Duplicate Help
  133. Solved: ODBC values into an array destination
  134. Solved: Delete or ClearContents
  135. Solved: Capitalising?
  136. Need help speeding up code part deux
  137. Open workbook if not open
  138. Solved: Change range in code
  139. Solved: Pivot Table
  140. Solved: Unprotect/Protect when updating/refreshing data
  141. Solved: Find
  142. Specify a save folder
  143. Yet another sorting task.
  144. adding rows
  145. If not in database then add to database
  146. adding a progress bar
  147. Solved: Msgbox formatting the text
  148. MsgBox and find Info
  149. problem with date format
  150. Solved: Help needed with sign in register
  151. Solved: MINIMIZE Button of an Excel 'FORM'
  152. Solved: Highlighting Selected Cell
  153. Solved: Problem with date command button in Sign in workbook
  154. Solved: Excel CommandBars in created session
  155. read data and put in array
  156. Solved: How to stop date updating?
  157. Solved: Saves workbook as todays date?
  158. If it finds "Customer" then run code if it dosen't skip code
  159. Solved: Implement formula as value in event code
  160. Problem With Stepping Thru VBA Code
  161. Solved: Display Protection Status
  162. Solved: Almost-Langford numbers
  163. Solved: Dynamic Combobox in a userform
  164. Solved: Userform checkbox's
  165. Solved: Terminology Stuff
  166. Date range issues
  167. Finding "Today"
  168. Long Code Help
  169. Solved: Code Error - Extra Column Created?
  170. Solved: Matrix type vlookup
  171. Function returning null value instead of string value
  172. Solved: ChkFolderExists not quite working
  173. Downloading file from internet
  174. Solved: moving data from sheet1 to sheet2
  175. Solved: How do I code this
  176. Sending emails to multiple recipients
  177. Solved: How to import text file & extract specified strings
  178. Automating pivot or static charts - bigger picture
  179. Help with autofilter
  180. Solved: search workbook
  181. Freeform Nodes
  182. print preview
  183. Solved: VBA - How to re-run a macro?
  184. Solved: how to pass arrays as procedure parameters?
  185. Solved: Problem with error handling with GoTo Statement
  186. play a sound in excel
  187. Solved: Copying coded worksheets
  188. Not Enough System Resources ... etc
  189. Starting Another "Instance" of Excel
  190. query results to a specific cell
  191. Solved: Duplicate Sheets with VBA - Error cannot complet task
  192. TREND v FORECAST
  193. Solved: VBA - VALUE Error
  194. Solved: Show previous value in a insert comment
  195. Solved: Reversing row/column in a paste
  196. Solved: Pictures dissapearing
  197. Help with cell selection query please.
  198. Backup workbook before modifying
  199. How to add columns to a Worksheet?
  200. Too Many Cell Formats
  201. Solved: grouping?
  202. Solved: Application Fails If Workbook Name Changes
  203. How to Force a Premature For-Loop Iteration
  204. Solved: Set Variables to Nothing
  205. Solved: How to convert to tab-delimited text files?
  206. protect a sheet
  207. Solved: Make a structured list in a textbox.
  208. Solved: Progress bar complications
  209. Solved: If condition for Find cell value
  210. Solved: counting columns
  211. Data Validation List: source from other Worksheet?
  212. Solved: remembering cell
  213. Excel 2003 vs 2000
  214. worksheet events issue
  215. Solved: Bonus question
  216. Forms & OptionButtons
  217. Solved: Insert comment pictures vba
  218. VBA execution speed
  219. Office Web Components - Excel
  220. Solved: Can you instantiate Class Module Object from Another Project?
  221. System beep
  222. link cell in sheet1 to cell in sheet
  223. Solved: What are some common file size factors?
  224. Add page if not enough
  225. Printout error?
  226. Solved: Fill active cell's row & column
  227. Use keys to speed searching lists
  228. Solved: Data Capture from Attached Device
  229. Solved: Defining Used Cells & Send to PPT
  230. Declare Publicly
  231. Solved: UserForm to retrieve sheet names from another workbook
  232. Turn worksheet into "userform"
  233. run code if find anything in row 2 of column
  234. Excel Macro-- How to Write a Path
  235. Solved: Understanding Functions vs. Subs
  236. Solved: Object Positioning
  237. Solved: Launch An Excel Workbook After Booting...
  238. Solved: Variable chart parameters
  239. Solved: Help understanding With End-With
  240. Solved: Saving workbook as a textfile...
  241. Using formatting for criteria
  242. Solved: Re: Exporting An Excel Chart / Range As a Jpeg
  243. Solved: Disable Auto Refresh on Open
  244. Kb entry to display long text
  245. Delete all rows that don't start with CRN or AT
  246. Second shot on explaining add to database if not in there
  247. Add a beep or any sound when done!
  248. Solved: Userform to Display a Range
  249. Solved: little help with add.charts
  250. Solved: Font Control for MultiPage