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