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

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