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