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

  1. Advanced filter question
  2. Solved: Dynamic named range
  3. export styles
  4. find text format
  5. Solved: Quick question on Filter
  6. Solved: Update links prompt
  7. '1004 Error' Message
  8. To "credit" or not?
  9. Solved: else and else if with part text
  10. Solved: taking a portraite page to less landscape
  11. Solved: left upto space
  12. Solved: How to Detect Formula Is Present
  13. Solved: Using VLOOKUP
  14. How to delete a worksheet from running code
  15. Solved: How does one create a calendar
  16. Calculating interest earned on accounts
  17. matching 2 column and return value
  18. Spreadsheet errors
  19. Solved: user form control problem - using names in loop
  20. Solved: Sum only Positive or Negative number
  21. Solved: VBA Macro to Print
  22. export a range
  23. Copy and paste help required
  24. txt files import into excel
  25. Solved: cut & paste assistance needed... please
  26. Solved: Extract Data from a Alphnumeric String
  27. speed up macro VBA
  28. tab to certain cells
  29. check a cell to see if it has a currency code
  30. Solved: Kill all combo boxes w/ one shot
  31. Solved: insert blank row for each full row
  32. Solved: Fill an array an easier way
  33. Linking two procedures
  34. Diifficult Range & Sum
  35. clear non integers
  36. Solved: Check if List box has anything selected in it
  37. Solved: CopyFile If
  38. Solved: Chart on a UserForm
  39. How to make 2 worksheet events work together
  40. date comparison on two ranges
  41. Solved: Auto filter
  42. Error Report
  43. Using an Automatic Max Scale on Charts
  44. Solved: Characteristics of an AutoShape Connector
  45. find a module
  46. Solved: This one may be WAY TOO DIFFICULT
  47. Solved: Check Cell Contents In A Column
  48. Solved: Contents of a dropdown Box
  49. Solved: Is possible to have the same
  50. Auto Filter Again
  51. Solved: Adding and Deleting Comments
  52. Picture in Worbook or in Userform
  53. Solved: VLOOKUP or some other way
  54. Early?late Binding?
  55. No records found
  56. Solved: Making room for a date
  57. Solved: Help! Next empty cell question
  58. Solved: "Dynamic" Range (for lack of a better term) not 'registering'
  59. Solved: reset Excel sheet count?
  60. Adding characters to hyperlinks.
  61. Solved: find the FIRST used row and column
  62. Date Problem
  63. Get VBA to check if cells empty before autofill?
  64. Open new excel and keep existing data
  65. Inbedded Objects with links
  66. Solved: Code wanted!
  67. Solved: Fill contents of blank cell based on cell value above
  68. Solved: The .FIND Method ... Arrrrrgh!
  69. Solved: The Agony of Defined Name Overrides
  70. RefreshAll web query problem
  71. Solved: ListBox Question
  72. determine if a sheet exist
  73. Newbie question re:Userform/ComboBox
  74. Solved: Update Values
  75. Solved: Excel VBA to format Word doc
  76. Solved: Macros and Formulas
  77. Solved: What Does VLOOKUP Compare to??
  78. Solved: Changing NumberFormat
  79. Solved: Stop Excel process
  80. open specific module
  81. Solved: How to colour tags?
  82. Solved: Like DSUM function
  83. error message
  84. toolbar do not show
  85. How Can I tap into Excel's "Insert Hyperlink" Dialog box
  86. Solved: VBA Projects Remain Open
  87. How can I speed this up?
  88. Solved: Edit Textbox after Format
  89. list of vb projects
  90. Solved: Sorting rows between rows
  91. Solved: VLOOKUP?s 3rd Arg ? Why Needed??
  92. Solved: Double click to bring up userform
  93. Solved: Identify array element
  94. Solved: Update biweekly date period
  95. Help with macro code alteration if possible?
  96. Solved: Copy and Paste from several workbooks to master workbook
  97. error number
  98. Transfer Data from a Database
  99. Excel Track Changes
  100. Add new name to dynamic range problem
  101. shifting focus to excel
  102. Solved: Text Boxes to be Initialized:
  103. clock in statusbar
  104. Solved: Text Box Data to be Copied:
  105. Detect an unprotected worksheet automatically
  106. Read from txt file in utf-8
  107. Field validation / conditional format
  108. Solved: Weekday from date
  109. Solved: Comparing 2 sheets + copying data from 1 sheet to the other sheet
  110. reset filter mode
  111. Solved: Run Time 1004 error
  112. Solved: Leading zero's for a SSN #
  113. SEnd an email from Excel without notifying the user
  114. Getting rid of extra spaces at the end
  115. Amount in word
  116. Autofilter based on value in particular cell
  117. Solved: Format certain cells in a worksheet
  118. Solved: Detect if a workbook is open
  119. Solved: set password on command button for macro
  120. Solved: Help with lookup and reference
  121. string name same as sub name - dynamic
  122. Solved: Automatic Sort After Data Change
  123. Solved: Parse XML Attributes with Excel VBA
  124. finding last row
  125. Listview and hh:mm format
  126. Place formulas by criteria VBA
  127. Solved: check if a cell has a bottom border
  128. progressor in status bar
  129. Clearer example
  130. Solved: how to hide drop-down list of pivot tables
  131. Referring to Trendline by name
  132. Aged Analysis Of Stock
  133. Solved: Practical limit to size of array?
  134. Trigger New Task in Outlook
  135. Solved: Use one procedure to end another
  136. determine the last save
  137. replace function
  138. Solved: Problem with comparing
  139. Solved: Map Network drive and save
  140. Column Sort as per Template
  141. Solved: Problem with INDEX , MATCH
  142. Solved: New instance of excel
  143. Guidence: Provide Functional Update To an Existing WrkBk
  144. avoide an error
  145. copying data
  146. Solved: Find last " " (space) in String
  147. An If formula?
  148. Macro for multiple charting of multiple datasets
  149. Array Constant
  150. Solved: Put data in Text Box via a Variable
  151. Solved: Counting Multiple Cell Values
  152. Extract data from a table.
  153. Solved: VB Components
  154. CELL
  155. Solved: get Location count and get next Location
  156. Are youlimited to the number of macro's in Workbook
  157. Solved: Highlight entire row when item is found.
  158. Retrieving different ranges of data from different workbooks
  159. Solved: Reading data from .txt file to excel in the format as in attachment
  160. Solved: VBA code to insert a formula
  161. Solved: Protect worksheet / Worksheet event
  162. Copy VBA code
  163. Excel access Internet throgh Proxyserver
  164. Open Lotus Notes mail with password and send the actice sheet
  165. networkdays-function
  166. hide/unhide columns
  167. Impossible Task Maybe ??!!
  168. last 10 procedures entered
  169. Solved: Convert Formula to Return a Row
  170. Solved: Match one worksheet with another worksheet
  171. Solved: textbox-linecount and individual lines?
  172. Does anyone use MS Excel Macro 4 sheets
  173. Solved: Sum of certain data for every unique client
  174. Clearing a ListBox
  175. screen updating
  176. Solved: Insert formula error.
  177. Solved: securing Vb from users
  178. Solved: Previous Cell
  179. find all cells with same ref and subtract accordingly
  180. Importing External Data
  181. Solved: if thisworkbook.visible=true
  182. Most efficient way to copy and paste
  183. Solved: More efficient way to use WorksheetFunction in loop?
  184. Stupid Button Question
  185. Reinstate User Toolbars Problem
  186. Adjusting my code:to fill only empty rows
  187. Solved: Sumif
  188. Solved: Delete rows based on condition
  189. Solved: Picture Code
  190. Solved: Shortcut to macro within macro
  191. Solved: Sort by color
  192. Solved: Merge Workbooks
  193. Solved: Changing Cell Fill Color Depending On Its Contents
  194. trapping error
  195. Solved: ListBox Sort
  196. Solved: Find Sheets in a Workbook
  197. Solved: Formula Challenge
  198. New SpywareBlaster Versioin Available
  199. Solved: Auto find duplicate entries
  200. Split Cells & insert rows for equal spacing
  201. Date conundrum
  202. Searching multiple cells
  203. Questions related to Online Quiz
  204. Solved: Calendar control woes
  205. Solved: Changing a minus to a plus
  206. Solved: COmbine columns
  207. Solved: Load AND unload?
  208. Solved: need some advice please
  209. Server login
  210. Help with running macro on another sheet
  211. Solved: Finding opposite entries.
  212. MAKE DISAPPEAR the reference in the graph!
  213. Inserting Columns
  214. Working with 2 workbooks/Finding/Inserting Data from one to another
  215. Delete Sheet
  216. automation error
  217. Updating of worksheet against data from another worksheet
  218. Solved: Unwanted quotationmarks
  219. Solved: Counting rows in an autofilter
  220. range offset
  221. pop-up toolbar
  222. Automate Emails for an Invalid Request
  223. toggle right click
  224. sheets exist
  225. Solved: Selective Event
  226. Solved: TextToColumns malfunction
  227. Most Popular
  228. Solved: Error handling problem
  229. Solved: concatenating a objectname with a variable
  230. Solved: calling a function according to a value in a variable
  231. Access - Excel link
  232. Solved: Toolbar hide problem persisting
  233. Draw line from 1 cell to another
  234. Conditional formatting color question
  235. Upper Case Dates
  236. Lookup and add additional information
  237. Solved: problem with application.match
  238. Excell relationship
  239. Solved: Checking for empty cells.
  240. Solved: Time the duration the code is completed
  241. Worksheet Menu Bar
  242. Solved: Delete rows code need to be faster
  243. Solved: How to enable/disable Controls based on ActiveSheet.Name
  244. delete an empty sheets
  245. Fetching Object Properties
  246. Solved: Month formula
  247. Solved: Concealing open workbooks
  248. Solved: split line in batchs
  249. Solved: locking a worksheet
  250. totally hide worksheets until password is entered