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. [SOLVED:] Extract One column from multi-column array
  2. Solved: Pease help on CTRL-SHIFT ENTER on my VBA Formula
  3. convert xls to csv large number problems
  4. SpinButton
  5. [SLEEPER:] Something weird with vba
  6. [SOLVED:] Get a line from a text file.
  7. Solved: Move numbers from DOC to XLS
  8. Solved: Find Duplicates
  9. Please help with my Pivot Table VBA Code.
  10. Solved: make certain cells visible
  11. Help regarding reminders about birthdays of employees in advance(2days)
  12. IF formula for identifying unique rows (quite confusing problem)
  13. Feedback form Help
  14. Excel save file - 2007
  15. Simple Copy and Paste Mystery
  16. VBA not working on both sheets
  17. Module to delete rows
  18. update data via listbox
  19. Conversion and Icons
  20. [SOLVED:] SpecialCells(xlCellTypeVisible) does not seem to work in range object
  21. [SOLVED:] Tabbing order
  22. passing FieldInfo value as a variable
  23. Solved: The magically disappering Excel Workbook.
  24. Using VLookup and Maximum statements or what will work
  25. Solved: Sumproduct - Summing
  26. Hiding Rows takes Time
  27. Solved: Removing a Item from Listbox.
  28. Self-saving workbook?
  29. Help with Create Hyperlinked List of Directory Contents
  30. VBA - Format with lanuage change
  31. Solved: Microsoft Internet Controls Library
  32. Help using Access as backend for Excel
  33. Solved: Copying an entire Letter from word document
  34. Solved: Formula to help identify specific words in titles?
  35. [SOLVED:] Time difference formula required
  36. Solved: Help with value testing
  37. Solved: creating recap with macro
  38. Solved: countif - help required
  39. Printing daily log sheet with preprinted dates (solved)
  40. copy entire column and paste into another workbook
  41. [SLEEPER:] Weird insert line problem...
  42. AUTOMATICALLY CLICK DEFAULT MESSAGE BOX
  43. Solved: Removing duplicates based on two columns
  44. Help with the Loop
  45. Help... What have I done !!
  46. Autofilter code not working
  47. Workbook Sequencing Only on Saves
  48. Solved: How to copy formatted number cells visible text?
  49. Solved: Sumproduct calculating total incorrectly due to date
  50. Searching within a pivot table
  51. Eventdriven XML Export
  52. need help with rounding formula
  53. Pointer to Workseet
  54. Solved: Form VBA
  55. Solved: Is there a way around using a tonn of ascii references......
  56. Operators in Arguments question
  57. Creat Pivot table by VBA
  58. Macro 4
  59. Loop through variables
  60. Solved: Search for cell values then sum scell to......
  61. Solved: parse and new column
  62. VBA code to enable autofilter on protected sheets
  63. [SLEEPER:] Populate ListBox with Filtered Records
  64. Solved: lost vblf's
  65. Solved: Problem with date Picker Control
  66. Solved: Problem in Find & FindNext for a Function call
  67. Solved: copy worksheet to another workbook
  68. Code moves cells out of range
  69. Save to SharePoint Library w/meta
  70. Change 1 character in cell
  71. [SOLVED:] Call every X seconds
  72. Transpose or array?
  73. Change Customer ID
  74. Solved: syntax: shell
  75. ActiveX in Excel
  76. text box
  77. find and compare
  78. Solved: Command button colour change if file missing
  79. Solved: Active cell display
  80. Weird Type Mismatch Problem (Cell Formula vs. Cell Value)
  81. Runtime Error 1004 with working accross worksheets & string concatenation
  82. How To separate VBA application into file
  83. Get a Structure from a Pointer
  84. Button embedded in a chart, xl2007
  85. Solved: User defined function and copy paste
  86. [SOLVED:] Help with MsgBox Function
  87. What Does “Insert Names” Mean on the VBE Screen?
  88. Run a macro contained in an add-in using keyboard shorcuts?
  89. plotting a named range within a named range
  90. Solved: Find in 3 colums and list the result in a list box..
  91. Completely at a loss...
  92. Solved: combine from all sheets
  93. Problem with Excel - Access macro
  94. Solved: Cells showing as formulas...not results.
  95. Text to Columns Wizard - Way to save off positions?
  96. Solved: PRINT AREA VBA
  97. Animated Gif Help
  98. Solved: How to copy rows in different worksheets created on the fly
  99. [SLEEPER:] Lock cell formatting but allow value input
  100. Solved: Remove All Comments
  101. Solved: multi columns selected
  102. Solved: Tracking changes with comments
  103. Macro to export cell values to Word
  104. Moving ExcelMacro to Access
  105. Get Data From Acess
  106. Solved: Cell reference in VB
  107. New landscape Word doc from Excel
  108. Open Publisher doc from Excel then edit
  109. Obtain version number of SharePoint document
  110. Solved: RecordSet and ListView
  111. Managing Duplicate Conditional Formatting Rules in Excel 2007
  112. Solved: Check 1st 4 chars & conditionally enter a string
  113. Scrolling issue, going too far
  114. Solved: vba to ID info in cells and find other cells with same info
  115. Pull data to new workbook with new sheet per workbook
  116. Search folder with a value in cell
  117. Button press effect in Excel Shape
  118. Solved: Seperate each recipient into own tab
  119. Solved: Excel match headers, append data
  120. Copy Folder to specified path...
  121. Automatic upload excelsheet (html) to web
  122. Solved: User Changeable File Paths
  123. Solved: Check if combo box is populated
  124. Solved: Limit character input in a textbox
  125. Solved: how can i change this code to identifiy the 2 digit no?
  126. comparision macro is very slow
  127. Solved: Problem with amended xld.sheetmanager code
  128. Solved: Deleting Rows based on criteria
  129. Solved: Buttons
  130. Solved: import empty column QueryTables thnks
  131. Solved: Condionally Formatting a Row Based on a Cell Condition
  132. Solved: Count unique entries that occur over consecutive dates
  133. Solved: Scrollbar
  134. Solved: Monthly to Quarterly Part 2
  135. Copy a table from an excel sheet to an Embedded Excel Chart Object's Sheet
  136. Runtime error '1004' Application-defined or object-defined error regarding if formula
  137. Solved: Can't get If,Or, to work
  138. Solved: Copying Named Ranges
  139. Solved: Changing time string?
  140. Solved: Adding a New Toolbar
  141. Solved: Formatting Dynamic Toolbar
  142. Solved: extend the border line
  143. How to acees server xml file
  144. Solved: Sum the distinct values under a specific criteria
  145. Solved: User Input With Options
  146. Library Not Registered error
  147. custom order?
  148. Copy Worksheets to a new Workbook
  149. Solved: faster way to delete row
  150. Save Data to a Closed Workbook.
  151. Solved: Cell value capture
  152. Getting Week Numbers to Display over Multiple Years without Resetting to 1
  153. Any of you guys familiar with web query...
  154. how to find last non empty cell in col and use it as input in a range
  155. Populate a field on a webpage and submit and record data
  156. Solved: Making CheckBox1 Selected By Default
  157. Preserving Objects and Collections
  158. Command Button Shrinkage
  159. Solved: VLOOKUP accross sheets
  160. Solved: Calling a Script From Another Module
  161. Changing CommandBars.Name
  162. VBA programming question on cell selection and optimization
  163. Help reg user form development
  164. Solved: Insert picture
  165. Interactive Drop Down List/file chooser
  166. Solved: If value found, copy range macro help!
  167. Solved: special sort
  168. Match columns linked to external workbook
  169. Solved: Colour change based on cell value
  170. Simple Copy and paste
  171. Using a click button to select data relating to checkboxes
  172. Sub routine isn't sending outlook message..
  173. Solved: Copy .txt file
  174. Solved: Sound alert
  175. VBA for batch upload
  176. Help with VBA code
  177. Solved: Error with Recorded Macro
  178. Solved: Time format in user form
  179. Solved: Format Chart Area
  180. I/O Excel to PicAxe Micro
  181. Solved: Looping through Worksheets and inserting a formula into a Range of Cells
  182. Solved: How do you create a quiz with microsoft excel 2007?
  183. How to escape characters in Microsoft Excel, such as an equals sign?
  184. Solved: Method "FileSearch" Problem
  185. Solved: Copy data from 1 workbook into another
  186. Solved: How to add new range in the VBA
  187. counting results from searchareas.
  188. Solved: Pulling Value Only (not equations)
  189. Macro To Merge Data from Different worksheets
  190. Solved: Please help tech wizards!
  191. Solved: listbox items as variables
  192. Solved: A list of distinct values
  193. Sleeper: Collection Class - Item Method
  194. [SOLVED:] Highlighting Duplicate numbers in excel only when they are next to each other
  195. Solved: OpenText Method: Excel remembers Last Import!
  196. Solved: Lookup Help
  197. Populate List Box in Excel with visible rows when worksheet gets filtered
  198. Solved: moving array to worksheet
  199. Solved: caclulating birthday in a userform
  200. Solved: Loop through a range and hide active Column
  201. help me plz
  202. Solved: Looping through autofilter, copy, paste
  203. How to improve the performance of this code
  204. Solved: Loop OpenText function
  205. Macro Help
  206. Excel wants to talk to Access
  207. Entering Selected Cell Values in Multiple Textboxes
  208. Solved: Change code to choose .txt file already open
  209. Checking existence of a text in SQL database table column.
  210. Paste Data From Excel To Access
  211. Solved: Is there a shortcut for this code?
  212. Solved: Remove last 4 rows from a listbox...
  213. Can't Exit Design Mode because 'ControlCommandButton1' cannot be created?
  214. Solved: Convert to Propercase Selectively
  215. Move multiple sheets from multiple files
  216. Creating dynamic Range for combobox
  217. Solved: VBA Web Query to google finance/reuters
  218. FORMULA FOR REPORT IN EXCEL
  219. From Excel to XML via VBA
  220. Solved: Test for Existence of Toolbar
  221. [SLEEPER:] Using VBA to move the mouse to a specific coordinate and left click?
  222. Solved: Add ListBox item if item exist just once...
  223. Solved: Disjointed Information to Table (Solved)
  224. Solved: copy defined rows
  225. Solved: Clicking CANCEL After Executing a Command
  226. Making graphs in loop
  227. WebBrowser Control with Animated Gif
  228. Transfering data from UserForm to specific cell
  229. How do I put Msgbox in between formulas in VBA?
  230. Open a workbook with a long file path
  231. Copying to multiple workbook coding..
  232. Solved: Extract distinct list from a range
  233. Solved: Scanning Program that converts document to excel
  234. Sub Returning Workbook
  235. Help with Variables in Ranges
  236. Unloading User Forms
  237. copy selected cell with links
  238. How do you create a VBA formula code based on Filename?
  239. Group Variables together
  240. Solved: Help with Objects in a Collection
  241. [SOLVED:] Prevent Function calls in worksheet when running macro
  242. Solved: Open and Close File
  243. Solved: Looping with textboxes
  244. Form Button Font Keeps getting smaller
  245. XP Visual Styles to Excel UserForm
  246. Solved: Macro for printing
  247. Macro to save file with active cell value with 3 date options
  248. Method to merge two excel files without links
  249. [SOLVED:] Working with CutCopyPaste Mode
  250. Dynamic hyperlink that can survive sorting