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. Finding Print Area in a excel worksheet
  2. Run Time err 1004: Unable to get the vlookup property of the worksheet function class
  3. Retain Comments in Printout of excel
  4. Solved: Digits in number
  5. Solved: Trying to Remove Quotes in txt File
  6. Application-defined or object-defined error
  7. Include Multiple column groups on every page?
  8. Conditional formatting
  9. Problem Changing Defined Name Scope in Excel 2007
  10. VBA to AutoSave and Copy to diff location
  11. SetFocus Method Not working
  12. Solved: How to write format code in VBA?
  13. Find Next Column
  14. Save range as a new file?
  15. Macro for comparing cells on 2 sheets in Excel
  16. Array of a custom class???
  17. Solved: No of characters in a formula
  18. Passwords Security
  19. Each subtotal signature require only at last page for each subtotal.
  20. Single or Double
  21. Solved: Print, Save As, Exit Sheet & close Current workbook
  22. Integer division
  23. Adding Custom button in titlebar of userform
  24. Creating number
  25. Sleeper: Resetting Used range with VBA
  26. Identify Conditional Formatting
  27. excel to work passing data dynamically with bookmarks in word
  28. Working with various Ranges (Named Range) and Worsheet Events
  29. Solved: Display Calculotor
  30. Solved: Place a comma in between two words
  31. How do i print LISTBOX CONTENTS INTO EXCELL SPREADSHEET
  32. Solved: truncate string and onward
  33. Solved: Sorting Email Addresses column
  34. Sleeper: Similar data
  35. Printing equation into cell
  36. Simulating mouse click on web page
  37. Solved: opening excel file using VBA
  38. Solved: How to start pasting on the last row?
  39. Start time help
  40. Excel open dialog box
  41. Solved: Add Formula to Cell Using VBA
  42. Solved: Copy data from one Spreadsheet to another and validate
  43. Help with creating Array from Checkboxes
  44. VBA code to force invoke Excel 2007 instead of 2003 (from Access)
  45. [SOLVED:] Toolbox icon in VBA
  46. Solved: Trim titles
  47. Combining and aligning data from multiple sheets
  48. Help with Arrays
  49. Solved: Offset to 1st & 2nd cell in row
  50. Solved: Copy a subset of a named range using Union
  51. Solved: How to use LookUp/If-Then in VBA?
  52. Script to remove custom views
  53. Solved: Pivot Cache Consolidation
  54. Solved: How to make a folder in the same path
  55. "File Locked for Editing" When Not Even Open
  56. Dividing merge cell into ten equal rectangles for inputing Digit?
  57. Solved: Finding non numeric in range using an array
  58. How to List Named-Ranges only from specific Sheet
  59. How can I grab the data from a LISTBOX and insert it on COLUMN "G1"
  60. Sleeper: Hide VBA operations
  61. Solved: hide the button for certain time of the day
  62. Solved: Row to repeat at bottom
  63. Solved: What's wrong with my Paste Special Transpose Code?
  64. validating values in excel using VBA
  65. Solved: Help deleting rows please
  66. Solved: Pivot Cache Consolidation
  67. Solved: How to Replace Horizontal Tab in Excel
  68. Solved: Worksheet Menu Bar
  69. Parsing Name Help
  70. Solved: reset picture# in Excel
  71. Solved: I'm stumped ....please help
  72. Sleeper: Disable "Show sheet tabs" option
  73. MsgBox vbYesNo help
  74. Solved: Convert Monthly to Quarterly using Macro
  75. Solved: Another Problem
  76. Sleeper: Evaluate method & For Loop: which on is faster
  77. End If without Block If
  78. Solved: Error "400" in VBA
  79. Adding code to a worksheet on the fly
  80. Solved: keep cursor in textbox...
  81. delete all except the last duplicate
  82. Help!!!!
  83. repeat rows at bottom of page
  84. Solved: How Does VBA Handle Multiple Conditions Within an If Statement
  85. Textbox help with msgbox
  86. [SLEEPER:] Return Value from UserForm
  87. Put textfile on desktop
  88. School exercise, i'm desperate
  89. VBa Code exist?
  90. VBA Calendar
  91. Permanently Hide Sheet Tabs
  92. Solved: Edit/update code in multiple workbooks
  93. Solved: Select a particular cell before closing
  94. Improve functionality of table
  95. Solved: SIMILAR NUMBERS
  96. Solved: Count Cell if it is numeric
  97. Worksheet Change event not triggering sub
  98. Solved: Renaming an opened workbook
  99. formating the calculation result
  100. New to forum, need help
  101. Solved: Select, Insert & Print Macro
  102. Solved: Auto populate a column
  103. Solved: Deleting unwanted worksheets in WB
  104. update page footer
  105. VBA to get details of files in a folder
  106. Solved: Delete a Sub Not needed anymore
  107. color cells
  108. Solved: INDEX/MATCH ...VLOOKUP?
  109. VBA - Advanced filter with data Validation
  110. [SOLVED:] Search different sheets
  111. Two search category & two search terms
  112. Duplicates and Deletes
  113. Solved: Search function VBA
  114. Solved: Help with my vlookup formula
  115. External Data
  116. cross tab excel refresh
  117. Solved: VBA Password Protection
  118. Solved: Limit Scrolling VBA
  119. [SOLVED:] Quite a complicated one...perhaps?
  120. Solved: External data problem
  121. Saving a copy of an Excel file without code behined it
  122. Getting the file name
  123. Compare dates of different years
  124. Asking the user where to output the macro's results
  125. Problem with copy data from a closed workbook
  126. filesystemobject
  127. hiding ribbons
  128. Find All and Return related Value
  129. Calling Excel shortcuts from VBA
  130. Solved: Merging Sheets
  131. Is it possible to link Excel and Access?
  132. Call value from worksheet
  133. Solved: Create 4 cell range to copy
  134. Issue with Listbox on Excel Userform.
  135. Copy specific cell range from different workbook to one excel sheet
  136. [SOLVED:] Sharing Modules
  137. Solved: Listbox selection as a parameter in data extraction macro.
  138. Solved: MROUND Function
  139. look for value then put them to the SampleSheet
  140. Pivot Table Conditional Formatting
  141. Shared workbooks and who is using them.
  142. Solved: If Statement
  143. Solved: Index / Match NA
  144. Conditional Formatting - Shapes
  145. minimising and unminimising ribbons event
  146. Pivot Table Formats
  147. [SOLVED:] ActiveChart Source PlotBy…With Scroll.
  148. Excel Vba and Access
  149. Force Excel to Stop Recognizing Numbers
  150. Exit userform and save changes
  151. Sort Question
  152. Solved: =IF Formula Help
  153. Paste Results to Spreadsheet
  154. [SOLVED:] How to create autofilter code using Textbox Userform?
  155. Solved: Conversion
  156. Solved: Clear The contents of Adjacent Cell
  157. Protection
  158. Solved: Copy rows from one sheet to another.....
  159. Solved: How do you eliminate the dropdown arrow in my autofilter code?
  160. Solved: MkDir advice.....please!!!
  161. WebBrowser in Excel UserForm
  162. Solved: how to do BACK (in workbook between sheets)
  163. How to delete expansion buttons???
  164. Solved: Checkbox code?
  165. combobos rowsource
  166. Data Validation list referencing
  167. Return web site data using Excel and VBA
  168. Solved: countif meet two conditions
  169. How to use of Macro to AutoFilter data on a shared workbook?
  170. Private Function problem
  171. Find out the minimum interior colorindex in each column
  172. problem with Find()
  173. Solved: Using data validation to return values
  174. Solved: Modify exiting VBA code for copied the particular sheet from multiple excel files.
  175. Excel VBA - retrieve Sybase TEXT data type
  176. Excel Turn Around Time Calculation
  177. entire row
  178. Solved: Object library invalid........
  179. subtraction
  180. Problems opening files
  181. Send Email to address in previous box
  182. Here's an easy one...MONTH
  183. Manipulate Cell Comments
  184. [SOLVED:] Get cell comment text in another cell
  185. [SOLVED:] Add prefix to a number
  186. Solved: Speed with array vs. dictionary
  187. Avg last ten
  188. Ont-time Alert on breaking threshold
  189. Copy range by condition
  190. Using conditional formatting in 2007
  191. Solved: AutoFilter, Criteria, Header
  192. Solved: How do you write this formula in VBA code?
  193. Solved: change font color after updated
  194. Solved: copy data automatically to another sheet
  195. filter
  196. [SOLVED:] Identify Button that has been clicked
  197. Run-time error for Highlighting
  198. Solved: Redim a range
  199. Solved: Excel VBA code to merge 2 columns into 1
  200. [SLEEPER:] Select cell before sheet deactivate
  201. Solved: UserForm Help for Travel Log
  202. Solved: VBA - Range and value match and replace
  203. Solved: Merging data from two spreadsheets
  204. Solved: insert a date for the current year
  205. Solved: Combine multiple sheet become one
  206. Can't get Match Index Formula right
  207. Solved: {Solved}calculation:multiply
  208. Solved: Always open a new instance of excel
  209. Data validation.........vba array
  210. Function to write the Interior Color
  211. entirerow.
  212. Solved: Range Select and Delete certain Values
  213. entirerow.delete
  214. Unable to set the Visible property of the Worksheet class
  215. need typo conditional formating code
  216. [SOLVED:] Modify exiting VBA code to open one sheet instead of several multiple sheet copied
  217. [SOLVED:] Using the Number Formatting Language to Specify the “BOLD” Attribute
  218. Variable
  219. Duplicate numbers
  220. Solved: How to get data from TextBox?
  221. VBA Code: Populating data in different sheets
  222. combined Vlookup & Hlookup?
  223. Exit Userform and close excel
  224. [SLEEPER:] Print a UserForm
  225. Solved: Syntax to "print in header"
  226. Solved: UF Copy Textbox Value
  227. Visual Basic (for applications)
  228. UF Radio Button get value
  229. How to find the Count of Records in List in atleast one-null scenario?
  230. Creating Userform Instructions
  231. Is there a faster way to perform this function?
  232. Solved: Tab
  233. vba Trim help
  234. VBA for pasting excel chart in powerpoint
  235. Getting the PivotTable Page data from another sheet
  236. Solved: Help with simple Macro (I'm sure)
  237. Solved: Help to apply contract penalties
  238. Solved: Prompt to enable macro
  239. Activesheet is not working. What may be the cause?
  240. How to call value from one sheet to another sheet using VBA macro
  241. UF Case Mutliple values in cell
  242. Solved: Control Filter
  243. [SLEEPER:] Code help
  244. Solved: vba autofilter
  245. Runtime Error 9
  246. Loopthroughsheets following code
  247. Extract to multiple text files
  248. Solved: PDF to Excel Data extract automatically
  249. [SOLVED:] Function to wait until a particular file exists
  250. Excel reversing cell value?