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

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