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

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