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. Code Review - Files from Directories
  2. Sending Email from Excel
  3. Solved: Still hate shapes...
  4. Solved: Time&Date Calculation and Formatting issue
  5. Solved: copy / paste Word file from 1 destination to other
  6. Solved: Yes/No Checkboxes Complete Before E-mail?
  7. Solved: Entering date into adjacent cell to selected
  8. Solved: Deleting cell contents rather than cell itself
  9. Solved: Browsing for folder shell
  10. timesheet code
  11. file search method using msoConditionIsExactly or msoConditionEquals
  12. datediff function
  13. AUTO UPDATE WBOOK
  14. user form pop-up with excel start
  15. Solved: SUMIF
  16. Solved: Help ...Passing Arguments
  17. Solved: Copy a worksheet from excel file and save it as another new file
  18. Solved: rank top4 with vlookup
  19. Solved: Reducing Userform Load Time
  20. Solved: problems with loop
  21. Solved: Macro Copying and Pasting
  22. Solved: Date functions
  23. Solved: Changing tab color
  24. Solved: offset property
  25. Solved: Assigning Values to Multiple Cells
  26. Solved: Using the Registry in an Application
  27. "Auto Complete" Internet Form
  28. Solved: Hide then unhide worksheet
  29. Solved: understand a file is open from a zip folder
  30. Solved: Copy a Hidden worksheet from a protected excel file and Save AS
  31. Solved: Saving contents of Clipboard
  32. Balance Sheet, SumProduct and VBA, how to?
  33. Solved: Picking out data
  34. Import Property of User into Excel
  35. Mac files
  36. Solved: Copy after the last line of data
  37. Solved: Moving data
  38. I could really use some help with this...
  39. Dynamic Named Formula for a table, not just one column
  40. Solved: Userform to edit filtered data
  41. select single cell as auto filter
  42. Solved: arrays
  43. Solved: External Links
  44. Solved: Create New Series on the Secondary Axis
  45. Solved: Check Cells and Before Close
  46. Solved: MsgBox problem
  47. rangename/column#/refersto ISSUES
  48. create wbook from wbook template
  49. Open document as "Read ONLY" only
  50. Solved: button for delete entire data in worksheet
  51. Print file using commandbutton
  52. Solved: list of exception for loop
  53. custom autoformat
  54. alternative to pivot tables
  55. Solved: Dynamic range reference
  56. Solved: Paste Special, Values
  57. tracking changes
  58. cell for read only
  59. Solved: Advanced import of txt files data in to Excel
  60. Simple Find Macro/Input box...
  61. Allowing validation on protected sheet
  62. Solved: Addins - Using worksheet as a template
  63. average calculation
  64. Call A Macro
  65. Solved: shapes.visible
  66. Reading RTF Format
  67. Maximization of Value by Changing Parameters
  68. Solved: Truly secure macro code with password?
  69. Solved: RowHeight - Multiple
  70. Solved: Need Help - Duplicate entries
  71. Solved: Date Stuff
  72. Solved: Check if Range is Empty
  73. Book.xlt and insert sheets
  74. Solved: Using VLOOKUP command
  75. Solved: LOOPING through a date range?
  76. Solved: Save Active Worksheet
  77. Solved: Register a dll via VBA
  78. Solved: Unique find with VBA
  79. autofilter with a cell as the criteria
  80. Solved: New Day, New Project
  81. Solved: trsnsfering value from column....
  82. Solved: AutoFit - Expand Cell With Data Entered?
  83. Search for whole words
  84. button link worksheet prob
  85. Autofilter copy/paste
  86. Solved: Hyperlinking to Embedded Object
  87. Solved: Using VBA to fill in Web Login Form
  88. Recording time spent on a worksheet
  89. ComboBox with 1 to 100
  90. Solved: Chart to only use visible data
  91. Solved: Hiding a password in a code
  92. Solved: Transfer dynamic cell value to second sheet
  93. Solved: Open another workbook w/o macros executing
  94. Solved: Creating/Updating ShortCuts
  95. Get data from XML file
  96. Using a path to the source ss
  97. Solved: Columns in MsgBox
  98. Solved: Document properties.
  99. Easiest Way To Build Currency Converter
  100. [SOLVED] get column letter
  101. Solved: Code inconsistancey
  102. send message to Outlook for user alert
  103. Fun Stuff - System Tray Icon for a userform
  104. Solved: Set a Trial Period For Use of Your Project
  105. pivot table: divide data columns with same data field
  106. Solved: Emailing file from excel
  107. Solved: word doc as attachement
  108. Solved: Call Macro From Hyperlink
  109. Solved: Good books?
  110. For each vs For I = ...
  111. Solved: Copy/Paste strange thing happening
  112. Getting an event from an ActiveX dll in VBA
  113. Solved: Copy Module or UserForm into another file
  114. Solved: Very helpful piece of code
  115. Solved: Distribute xla in other language versions of Excel
  116. Embedded Object "Management"
  117. Embedded Charts or Chart Sheets
  118. Solved: Copy a hyperlink address from a website
  119. this file is opned from....
  120. Bad coding habits
  121. Solved: Check if IE is running
  122. Creating Pivot Table using Userform
  123. if function using option buttons.
  124. Unique Entries to be dispalyed in drop down list as per renge given in data sheet
  125. "Pause" Checking ...
  126. Image path (url) in cell A1
  127. Solved: Excel confirmation messages
  128. Image Control changing images from network based on data validation
  129. Is formula solution available?
  130. Solved: Return based on mutliple criteria
  131. [SOLVED] Copy, destination & paste special
  132. Solved: Delete line if....
  133. Filtering a ListBox
  134. Solved: Add In Problems
  135. Solved: macro doubt
  136. Data import from web
  137. Solved: "Integer" vs "Long" in For...Next Loops
  138. Populate list box from another sheet
  139. Add ins Order
  140. Office 12
  141. VBA to replace ranges of array formulae
  142. Solved: Concatenate problem
  143. Only if has value
  144. Extracting data from pivot table
  145. Solved: need help urgently
  146. Solved: Looping in Userform
  147. find all cell containing comments
  148. Conditional Formatting
  149. Solved: Array to store range
  150. Putting in 1,000's of hyperlinks.
  151. COUNT VALUE AND BLANK CELLS VALUE
  152. Weekdays between two dates
  153. Solved: Selecting a different database in Lotus for automated message
  154. clear memory?
  155. Solved: Getting rid of old data...but keep formulas
  156. Select or If Statement?
  157. Solved: minimizing all windows except mine
  158. Solved: Existing codes need help PLS
  159. speed up link s
  160. PO numbers
  161. Export to excel
  162. Solved: Altitude estimation program
  163. Solved: Help with a Vlookup function.
  164. frustration with protecting a sheet!
  165. Present Value
  166. Solved: links
  167. find & open a file
  168. Count rows between two range
  169. Solved: Clipboard
  170. Conditional formatting question
  171. programmatically clearing checkboxes
  172. Create Excel add-in
  173. Solved: Finding number of items in an Array
  174. Solved: Insert columns in multiple sheets along with formula in a specified row numbers.
  175. Solved: Merge Workbooks
  176. Solved: Worksheet function help
  177. [SOLVED] SaveAs Then CopyDown Then Sort
  178. Solved: Changing the column order in a worksheet according to an array
  179. Function dosn't update value
  180. Solved: Combining Lookahead and Lookbehind in regular expressions
  181. Solved: Custom right-click menu
  182. Tab Order Screwy
  183. Center Across Selection ...
  184. Cannot stop Highlight
  185. how to do a variable odbc/.mbd database query
  186. Solved: Preventing user entering duplicate values in a cell range
  187. Solved: If, End If; UserForm textbox to numerical variable
  188. Solved: Offset? ActiveCell?
  189. Solved: Error handling
  190. Solved: Need To Know How To: Reference a column Range in VB
  191. Solved: Defining font colors in range
  192. Solved: Progress Bar Help
  193. Not close thead when I close excel
  194. Multiple range copy and paste
  195. How do I change the type of recipient of an automated email
  196. Solved: work rates
  197. Solved: Remove blank rows
  198. repeate an action
  199. Complex numbers in VBA
  200. Solved: Heat Index Formula
  201. Solved: Function Won't Execute On Spreadsheet
  202. Solved: Faster than Vlookup
  203. Hyperlink issue with LOCAL range names - sheet name change kills hyperlink address
  204. Help with user forms add and subtract
  205. reverse columns
  206. replace all
  207. Solved: TMP
  208. copy all modules
  209. Delete row if cell is empty
  210. Solved: Disable Workbook_Open macro when opening another workbook
  211. Solved: concatenating & shifting cells
  212. Query Access from Excel
  213. Solved: Problems Working with Protection
  214. Solved: Color Names
  215. Solved: I have to tell you this
  216. Solved: Code From excel-97 To Excel 2003...
  217. detect if Outlook is open
  218. Solved: vlookup and the value #N/A
  219. Solved: How do I say "begin with"
  220. Issues with arrays/collections/etc
  221. Solved: Kangaroo Problem
  222. Solved: Copy sheets into 1 workbook
  223. Highlight range used in formula
  224. Add a day to a date
  225. Pivot
  226. Solved: Input Box
  227. List Box
  228. Solved: Macro to insert new worksheet
  229. Conditional Formatting for data groups
  230. line of code
  231. Solved: Merge ranges based on condition
  232. Solved: API Call not working
  233. Dialogs...
  234. Progress Bar
  235. Searching all workbooks in a folder
  236. tick boxes
  237. Query for data from a Web page
  238. Solved: Command button to add items on Userform
  239. Finishing touches
  240. Solved: Scripting.Dictionary question
  241. Solved: Userform displays ? for cell text that uses "Alt+Enter"
  242. Solved: How to run update query on Access table from Excel VBA
  243. Solved: Copy rows based on user selection
  244. Browse Function
  245. Copy and paste from IE to book
  246. Solved: Search for word and delete text
  247. Advanced filter question
  248. Solved: Dynamic named range
  249. export styles
  250. find text format