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