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