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. Sleeper: Macro from Sub to Function question
  2. [SOLVED:] Dealing with different workbooks
  3. [SOLVED:] How to create xla for Excel from outside
  4. Sleeper: Calculate lookup table
  5. [SOLVED:] What's the syntax for adding colour?
  6. Sleeper: Can't run second times in VB code!
  7. [SOLVED:] Help with "Get File List" Macro
  8. [SOLVED:] Popup blocking my Progress
  9. Sleeper: Display clipboard contents
  10. strange characters input from text file
  11. [SOLVED:] Need Help writing a Macro for a Bill of Material
  12. [SOLVED:] Macro to get HD info or computer name?
  13. Sleeper: Userform pop-up when inserting a comment
  14. Sleeper: Importing selected data from 3 html tables
  15. [SOLVED:] Auto Sort a Worksheet when selected
  16. Sleeper: Trace User changes/force save via VBA
  17. [SOLVED:] Is it possible to code this !!!!
  18. [SOLVED:] Combine sheets
  19. Sleeper: Picking up the speed?
  20. Sleeper: Initialize a UserForm
  21. Sleeper: Drop down list to activate sheet?
  22. [SOLVED:] ElseIf..nightmare!
  23. [SOLVED:] Warning if quarterly forecasts exceed annual budget
  24. [SOLVED:] Find two minumum values from a range
  25. [SOLVED:] Excel's Status Bar
  26. [SOLVED:] With Statement with multiple arguments
  27. [SOLVED:] Using yields from another ss
  28. [SOLVED:] If Statement
  29. [SOLVED:] Delete Userform Picture
  30. [SOLVED:] Help with border macro
  31. [SOLVED:] Disable Enable/Disable Macro window
  32. [SOLVED:] Help with value from userform
  33. [SOLVED:] Control the command button
  34. [SOLVED:] Problem: Generate sequences
  35. [SOLVED:] Function acting funny
  36. [SOLVED:] Save charts of a workbook into another new workbook
  37. [SOLVED:] Another border question...
  38. Sleeper: Comment position
  39. [SOLVED:] turn formula to a vba function
  40. Sleeper: Lotus Notes view to excel sheet
  41. Sleeper: Setting print settings in VBA
  42. [SOLVED:] VBA to Identify Negative Balances
  43. Sleeper: Sending email via Lotus Notes
  44. Solved: Vlookup with Multiple Returns
  45. [SOLVED:] Converting Text to Worksheet Hyperlink
  46. [SOLVED:] Delete empty rows
  47. [SOLVED:] statistical function using VBA
  48. Solved: Wrapping text question
  49. [SOLVED:] Formula to return monday of current week
  50. [SOLVED:] Coding Error :(
  51. [SOLVED:] Excel Password to modify in Macro...
  52. [SOLVED:] Copy a formula on a worksheet by the number of data rows on a different sheet
  53. [SOLVED:] Can an event macro be called?
  54. [SOLVED:] Extract numbers from texts and do substraction
  55. [SOLVED:] Copy selected column in listbox to a new worksheet
  56. [SOLVED:] Auto Save With Date
  57. [SOLVED:] Protect worksheet tab name
  58. [SOLVED:] Find Method Question
  59. [SOLVED:] Inconsistent Function Return
  60. Sleeper: Choosing formula in combobox
  61. [SOLVED:] Command button attached to Text box
  62. [SOLVED:] Type Mismatch error
  63. Sleeper: Form Date
  64. [SOLVED:] Edit sheetname
  65. [SOLVED:] Order alphabetically
  66. Sleeper: Link Excel to pdf
  67. Sleeper: VBA array questions...BIG project
  68. [SOLVED:] Function tweak
  69. [SOLVED:] Problem whit a macro
  70. Sleeper: Filter Problems
  71. Macros Assigned to AutoShapes
  72. [SOLVED:] Can't Find a Link to Personal.xls
  73. [SOLVED:] 'Application.Volatile True' question
  74. [SOLVED:] AddIn Installation
  75. Sleeper: Compare parts of a spreadsheet
  76. [SOLVED:] Conditional formatting
  77. [SOLVED:] Chartobject appears with 30+series already plotted
  78. [SOLVED:] Protecting cells
  79. Sleeper: Getting error in SQL
  80. Sleeper: Selecting rows in between 2 speicific words
  81. [SOLVED:] Global Templates
  82. Sleeper: Help needed with VLOOKUP
  83. [SOLVED:] Do Loop and Merge Texts
  84. Sleeper: Help working with ranges doing text comparisons
  85. [SOLVED:] Bypass "Disable Macros" option
  86. Sleeper: Password to update links
  87. [SOLVED:] SaveAs Help
  88. [SOLVED:] Need Scheduler General Solution
  89. [SOLVED:] Back-up / Different Paths
  90. [SOLVED:] opening a password protected file using a macro
  91. [SOLVED:] Vlookup
  92. [SOLVED:] Border Row Macro problem
  93. Sleeper: Allow autofilter on protected worksheet
  94. Sleeper: Override Outlook Do you want to send option
  95. [SOLVED:] VBA Book recommendation
  96. Sleeper: Saveas dialog
  97. Sleeper: Creating custom event
  98. Sleeper: A few questions
  99. [SOLVED:] Assigning data from a range to a combobox
  100. [SOLVED:] This should be easy
  101. [SOLVED:] Variable Help
  102. Sleeper: Problem while running protected macro
  103. Sleeper: Quantity Limit on Copying Sheets
  104. Sleeper: Worksheet accessing
  105. [SOLVED:] If Statement
  106. Sleeper: Filling in website forms
  107. Sleeper: IsError
  108. [SOLVED:] Button to hide/unhide all empty rows? (Excel 97)
  109. [SOLVED:] Do something when specific cell selected
  110. Sleeper: Print VBA Userfrom for a Excel Workbook???
  111. Sleeper: Minimizing code
  112. Sleeper: Current page method of pivot field failed
  113. [SOLVED:] Creating userforms help
  114. [SOLVED:] Using If Then Else statement I think?
  115. Sleeper: Preventing comments
  116. [SOLVED:] Textbox Data
  117. [SOLVED:] Unable to edit cells in excel
  118. Sleeper: Logging of search results
  119. [SOLVED:] Comparing part of a Cell volume against a range
  120. Advice: Extending Rows and Columns
  121. [SOLVED:] Show Definitions of Named Styles
  122. Sleeper: Worksheet Protection
  123. [SOLVED:] Strange Results From A Prompt
  124. Sleeper: IsUDF Function
  125. [SOLVED:] Sort and insert blank row after groups (Excel97)
  126. Sleeper: Paste not available due to Application event.
  127. [SOLVED:] Save with file name issue
  128. Sleeper: VBA PasteSpecial (xlAll) pastes picture not data
  129. [SOLVED:] Help with a range
  130. [SOLVED:] Show Consecutive Entries..
  131. [SOLVED:] Merging cells problem
  132. Sleeper: Auto-copy if 'Yes'
  133. Sleeper: Reset of Auto-Filter
  134. Sleeper: Managing Comments
  135. Sleeper: Comparing arrays
  136. [SOLVED:] Multi line MsgBox
  137. [SOLVED:] Link Excel files with color
  138. Sleeper: Using the sheet tabs as my validation list
  139. Sleeper: Cell to reference sheet tabs in code.
  140. Sleeper: Search sheet
  141. [SOLVED:] Command Button to save & close workbook
  142. Sleeper: Checkboxes on worksheet
  143. [SOLVED:] Sort of an Excel calendar
  144. Sleeper: Last Row in closed workbook
  145. [SOLVED:] Change color of background in MultiPage Control for UserForms
  146. [SOLVED:] In Macro - Clear Clipboard / Free up Memory
  147. [SOLVED:] Bogus Dates
  148. [SOLVED:] Characters limit in Excel's Cells
  149. Sleeper: Using "Autofit" for merged cells
  150. Sleeper: Locking project after importing
  151. [SOLVED:] Referencing Columns in loop
  152. Sleeper: Protected sheets and Links?
  153. [SOLVED:] How to Recover Columns That Are Off the Sheet
  154. Sleeper: Copy paste transpose multiple sheets onto one sheet
  155. Sleeper: Javascript pop-ups/Web Queries
  156. Sleeper: Inserting (not entire) rows after groups (excel 97)
  157. Sleeper: Need formula help
  158. Sleeper: Error: Push Excel Named Range Values to Bookmarks in Word
  159. [SOLVED:] How do you make range A sheet 2 equal rangeB sheet 1??
  160. [SOLVED:] Datalabels not appearing on chart
  161. [SOLVED:] Assistance with finding the last value
  162. Dynamic Range and Pivot problem
  163. [SOLVED:] If formula
  164. Sleeper: Problem with sheet search
  165. Sleeper: Inserting Excel OLE Object
  166. [SOLVED:] "OpenClipboard" Syntax
  167. [SOLVED:] CutCopyMode ... How Is It Used??
  168. [SOLVED:] VBA Coding Help
  169. [SOLVED:] How to Clear an Array
  170. [SOLVED:] Display decimal values in a text box
  171. [SOLVED:] Data Validation
  172. [SOLVED:] UserForm and Adding up columns
  173. [SOLVED:] Stay in TextBox - UserForm
  174. [SOLVED:] Using a closed Workbook file
  175. [SOLVED:] Windows search
  176. [SOLVED:] Check Box
  177. Sleeper: Serial Port and Timer (sleep or delay)
  178. Sleeper: Threading in VBA
  179. Sleeper: Searching, Autofilter, Double Input
  180. [SOLVED:] Dynamic Arrays Question
  181. Sleeper: Spliting of data inside each sheet
  182. Sleeper: Com addin
  183. Sleeper: Pivot table
  184. [SOLVED:] Using EOMONTH in code with Excel 2000
  185. [SOLVED:] Use of Static Statement
  186. [SOLVED:] Combine duplicate records and delete
  187. [SOLVED:] Compare 2 columns, add blank rows
  188. Printer Details VBA
  189. Sleeper: UserForm with Feed back from the Excel Sheet
  190. [SOLVED:] Use of Dictionary
  191. [SOLVED:] Cells.Find not working properly
  192. [SOLVED:] One Routine for Multiple Menu Events
  193. [SOLVED:] ActiveX Checkboxes on Worksheet
  194. [SOLVED:] Make cert
  195. [SOLVED:] Matching cells
  196. Sleeper: How manipulate dates??
  197. [SOLVED:] Clarification on Array Type
  198. Sleeper: How let the custom menu start with excel opened?
  199. [SOLVED:] Message Box
  200. Sleeper: UDF - show partial results in formula palette
  201. [SOLVED:] Conditional Formatting a row - several conditions
  202. [SOLVED:] Check time
  203. Sleeper: Time in VBA - Display's in Serial Number
  204. [SOLVED:] Vlookup Help
  205. auto open new file and save as range name
  206. Sleeper: Custom Icons in Excel
  207. [SOLVED:] How to Modify a Range Format
  208. [SOLVED:] UserForm - Print out - with Data
  209. Sleeper: Using tab key on a form
  210. [SOLVED:] Autofilter via a form - not working
  211. VBA excel
  212. [SOLVED:] Need more efficient implementation
  213. [SOLVED:] Cell Value in Header
  214. [SOLVED:] Statement Efficiency
  215. Sleeper: I am back with a new set of questions
  216. [SOLVED:] Formatconditions for dynamic range
  217. Sleeper: Searching For the Best Statement to Define a Named Range
  218. Sleeper: Printing entire contents of a cell
  219. [SOLVED:] Guidance and Direction
  220. [SOLVED:] Putting values in text boxes
  221. Sleeper: Memory or Cache Problem
  222. [SOLVED:] How do you Create an Embedded ComboBox
  223. [SOLVED:] Replace macro
  224. [SOLVED:] Const for userform name?
  225. [SOLVED:] Search worksheets in folder and sub folders
  226. Sleeper: Pivot table and function
  227. Sleeper: Using J-Walk's FaceID Tool
  228. Sleeper: Transfering data value from 2 Wbook...
  229. Sleeper: Hiding error messages
  230. [SOLVED:] -- in a formula
  231. [SOLVED:] Challenging Formula Question on Timesheet Calcs
  232. Sleeper: Like Function
  233. [SOLVED:] Date format in userform text box
  234. [SOLVED:] Excel Mod function error
  235. [SOLVED:] Copy cells to closed spreadsheet
  236. Sleeper: Inserting spaces
  237. Solved: Phantom Breakpoint
  238. [SOLVED:] Array question
  239. [SOLVED:] Listbox problem
  240. [SOLVED:] Opening a workbook
  241. [SOLVED:] Viewing listbox items problem
  242. [SOLVED:] Bogus Range?
  243. Sleeper: Non-Printing Characters
  244. [SOLVED:] Problem with Application.InputBox
  245. Sleeper: Problem in Saving to Mp3 File back
  246. [SOLVED:] Multi select list box
  247. [SOLVED:] sending an email from the file location
  248. [SOLVED:] Another listbox selection problem
  249. [SOLVED:] Removing the Toolbar Options/Customize function
  250. Sleeper: Userform transfer variables?