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

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