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