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. Do While question
  2. Automation Help
  3. Placement of a method
  4. EXCEL COMPATIBILITY DRAMA
  5. countif forumla
  6. hide textbox
  7. Solved: Delete duplicated, tally to make report
  8. Invalid forward reference error
  9. Speeding up the processes
  10. Solved: input data to post in worksheet
  11. Solved: Two input variables at vlookup
  12. Problem with Code (Inserting New Row)
  13. List box from columns?
  14. Formula -
  15. Solved: any way to delete & refresh contents in a dropdownbox?
  16. Problem with .PasteSpecial (xlPasteValues)
  17. Excel procedure to run Access Query using ADO
  18. Help: How to make list value change with the source
  19. UnprotectGreenCells
  20. How to find the Last Used Row on Each Sheet
  21. Solved: Change Cell Colors By CF
  22. Adaptive Database/Table
  23. Sumif with multiple criteria?s from another worksheet
  24. Excel Hyperlink
  25. Highlight cells on combobox selection
  26. Solved: Excel data organization nightmare
  27. Challenging macro
  28. search data from other worksheet
  29. Forms/windows or whatever it's called
  30. Coloring of the tab of a worksheet
  31. Solved: Copy/paste from all worksheets, except sheet1
  32. Forcing .xls to open in 2007
  33. Backgrounf formatting in Text Control
  34. Solved: Formula - Runtime 1004 Error
  35. Paste Special Bitmap Excel VBA to Word
  36. excel formaula
  37. Solved: VBE column references
  38. Solved: VBA Combo Box Coding
  39. Option choices - how do I export results?
  40. Solved: Procedure Too large to complete message.
  41. Return named range with vba
  42. Solved: Hyperlink on menu button
  43. Can't get a result of formula
  44. Macro help..
  45. Sharing: What VBAx Is All About- Give It Up & Smile
  46. To Compare 2 Sets Of Data And Change The Values Accordingly
  47. Solved: Value Added Tax conversion problem
  48. Import Txt and Parse
  49. Solved: Expiration Date
  50. Stop User from Entering Formulas
  51. Cell contents become ###
  52. Self filling combo boxes
  53. how to get: Index function keep value?
  54. Find Range & Fill Down
  55. Leave out blank items in combobox
  56. problem with paste to active workbook
  57. Help: HOw many color is there in Excel
  58. insert pagebreak if chart is not fully displayed
  59. SECURING VBA CODE
  60. import worksheets from changing workbooks name
  61. code to tell excel which folders to look into.
  62. stop clock help needed!!!
  63. Linking Problem
  64. The "BEST" formula function in Excel:
  65. Scrollbars for a Frame?
  66. Check if workbook exists
  67. How to position a chart?
  68. Solved: Understanding VBA minutes
  69. Creating the user GUi forms the right way
  70. Getting to know what element of ComboBox has been selected
  71. Store Value of Last Row even after the procedure ends and Excel Closes?
  72. Listbox Count
  73. Solved: Pivot Table Formatting
  74. Help with deleteing row conataining #VALUE!
  75. Solved: Simple Floating Toolbar - enhancement
  76. Forms, textboxes & labels
  77. Excel and Notepad: how avoid additional inverted commas after copy and paste?
  78. Test if Current Dir is Read Only
  79. Values and formats of only visible sheets and ranges copied to a new book
  80. Calling UserForms: FormName.Show or Dim Object/Set New?
  81. pivot tables and
  82. Solved: referencing different cells for calculations
  83. Solved: For Each Loop through Worksheets Collection
  84. Solved: Passing & Returning array to/from Property Get and Let
  85. Solved: Range object Id property
  86. freeze pan
  87. adding image to vba loaded userform sourced in sheet
  88. Solved: DisplayFullScreen Question
  89. users access
  90. Save a copy solution
  91. Solved: How to tell if no value is selected in a listbox
  92. Solved: How do I force recalulation of custom function on Workbook_Open?
  93. How to show Form abobe selected cell?
  94. VBA to grab data from other .XLS file
  95. Creating a Pivot Table using VBA
  96. Solved: Adding Sheets By Day Order
  97. Named Range issue using file online
  98. MultiPage manipulation
  99. Solved: Putting String Array to cells directly
  100. Solved: How to add an Accelerator to a Caption?
  101. Code for a find sort and copy.
  102. Weird runtime errors
  103. Solved: Clear white space off each column of each sheet of a workbook
  104. Solved: DISPLAY "0" INSTEAD of #NUM!
  105. Solved: Multidimensional Array
  106. Presenting two datas in a graph
  107. Solved: Replace tilde character fails
  108. Centering Text in a Message Box
  109. Solved: Formula or vba required for most frequent text in an array.
  110. Solved: Non-Contiguous Reference Clear Contents
  111. Creating a graph from a selection
  112. formatting a label
  113. dropdown on a form
  114. Solved: Sorting a Range, Header info?
  115. Help: Worksheet_change event disable "undo"?
  116. Solved: For Each Loop Through Sheet Collection Getting Wrong Results
  117. Random Numbers via HTTP
  118. Help Adding a constant text to a numeric cell
  119. adding new items to a dropdown
  120. Collect Data via The Web
  121. Editable Worksheet_Change result
  122. Solved: DATA VALIDATION
  123. Setting the limits in y-dimension for a graph
  124. Solved: ? Better way to code
  125. Number of work hours between two dates
  126. Solved: Highlight Text in TexBox on UserForm Open
  127. Controls on sheet OTF
  128. Help: Excel object size unit
  129. copy paste
  130. Copy data from excel to another application
  131. Solved: Sorting on each sheet balks
  132. Solved: multi summation of columns
  133. Why does this Crash
  134. repeating/looping through code
  135. inputbox variable validation
  136. Solved: If Instr line of code assistance needed
  137. Solved: How to move a comment?
  138. Why can't i select things on non-active sheet?
  139. Solved: Populate listbox
  140. To a.Copy/b.Paste or to b.Value=a.Value
  141. Solved: import multiple text files from listbox
  142. Collect Data via the Web: redux
  143. Public variable doesn't reset
  144. populating lists
  145. How to clear a userform after completion
  146. Solved: any way to clear textboxes on a userform?
  147. Consolidating multipule workbooks
  148. Declaring a variable and assigning a value to it at once
  149. Compare and Print with VBA
  150. Solved: one source two targets, pick with dv
  151. Solved: Setting Array for Two Sheets- Almost there
  152. object question
  153. Solved: Replace Method using variables to find/replace
  154. Solved: Multiselect listbox
  155. Solved: Inserting Blank Row
  156. Solved: update inventory when receiving and shipping
  157. Solved: Code for buttons
  158. Solved: How to add image to chart series point
  159. VBE opens by itself
  160. Solved: Find last row, Array Worksheets via Function
  161. Solved: Schedule a macro
  162. Solved: addTextBox: how to find points from top/left of a specific cell?
  163. Solved: Reorganizing Data
  164. find last cell with formula
  165. Setting up a UserForm
  166. Solved: How to Force a Formula to Calculate
  167. Alternating row colors while sorting???
  168. Solved: if value less then 5 show warning in worksheet change
  169. Difference between Sheet and Worksheet
  170. What object is missin here (error 424)
  171. Updating graph automatically once the data changes
  172. Solved: sum visible rows only
  173. Solved: Rolling average
  174. Solved: Building add-in errors
  175. get letter of the active column
  176. Opening workbooks via shortcuts
  177. Solved: Layout of Monthly Data needs to change
  178. Solved: Setting up a global dictionary
  179. hiding/unhiding a page on a userform
  180. Lock record creation in Excel
  181. Solved: Export data to .txt file
  182. Listbox Multi column error
  183. Different ways of copying
  184. Solved: End For Next routine on error
  185. Forumla Problem
  186. Method 'Range' of Object_ Worksheet' failed
  187. Solved: Extended 'ControlTiptext' for combobox items
  188. Structure of the array that is returned by ClipboardFormats
  189. Copying from one sheet to another
  190. check if Access file is open and who the userID is
  191. Solved: Sort list Box
  192. Lock active cell based on value in above cell
  193. Solved: Place Mult Select Listbox selections in specified cells
  194. "FIXED OBJECT WILL MOVE" ERROR IN EXCEL
  195. Solved: Syntax question: Range(....)
  196. btn click userform add row
  197. Solved: Getting Hyperlink from cell
  198. Solved: Method to instruct how many times to do something?
  199. Solved: Weird workbook on open
  200. column question
  201. flashing label
  202. Setting values for x-axis
  203. Solved: Connect Combobox to Named Range
  204. Problem with Excel 2003 XLA (Menu) Add-In
  205. Listbox problem
  206. Solved: WorksheetFunction.Vlookup Different Workbook Reference
  207. Cell swapping
  208. "Out of memory"
  209. HTTP: Yahoo Currency Conversion
  210. Solved: tooltip
  211. add a numerated worksheet
  212. Copy and paste macro different worksheets
  213. must activate sheet before paste?
  214. advanced graphs - plotting
  215. Edit Button images
  216. Solved: Copy multiple Excel Sheets
  217. Form not working, Cracking me up!
  218. Using sound in excel 2007
  219. loading all add-ins at one stroke
  220. Import Text File to tab in sheet
  221. Solved: 'Custom' data validation
  222. Solved: Print Multiple Worksheets Error
  223. Listbox columns from 2 sheets
  224. Click on a cell, which one was it?
  225. date of last backup
  226. Solved: Temporarily Remove Conditional Formatting
  227. Solved: Passing row height properties to array
  228. Pasting some tables form Excel in Word
  229. Can I use if, sum, match and offset functions to do this??
  230. Solved: ScreenUpdating Issue?
  231. Countif multiple criteria
  232. Solved: Getting Data From a Closed Workbook
  233. Solved: Writing to specific sheets on specific cells
  234. Solved: CHANGE FROM ALL UPPER CASE
  235. Workbooks.Open Does not Error if Workbook is not Present
  236. forms-comboboxes & textboxes
  237. Still a challenge
  238. increase numbers by percent in a specific column
  239. MultiPage -how to change Page color?
  240. Solved: Sum Across unknown Number of Worksheets
  241. I don?t want the hide cell to be copying!! How to do it?
  242. Hide "track changes" option
  243. I need a menu bar in a userform
  244. Seek help for value
  245. Solved: Read string variable while ignoring case sensitiveity
  246. Solved: Debugging Immediate Window Question
  247. IF-Then-Else in VBA help needed
  248. copy sheets and files
  249. Solved: Find "/" in string & debug.print ?
  250. Userform Save with contents of TextBoxes