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. sort worksheets not case sensitive
  2. Changing Window name
  3. User defined function
  4. Lock cells
  5. Indentifying Current Module
  6. Macro to extract data from another workbook
  7. Preventing a Formula from Executing
  8. How to classify different rows to same group
  9. SaveAs is disabled.
  10. Solved: Group All Objects on a Active Worksheet
  11. Solved: Scroll Bar in User Form
  12. mail range
  13. Advanced Filter for 2 separate lists
  14. Solved: Mp3-information through Vba?
  15. AutoFilter Stopped Working
  16. Sort a named range
  17. IF Statement, with OR
  18. multiple line search then copy to new sheet
  19. Import Text File Problem
  20. Insert multiple tables in Word via Excel macro
  21. Solved: Error Message On Protected Worksheet
  22. Subtotals & More!!
  23. formatting Word tables via Excel macro
  24. EXTRACT SUMMARY DATA FOR JOURNAL ENTRY
  25. Solved: Position show values on chart
  26. Solved: row increment
  27. Finding a cell
  28. Send email with attached file (vba)
  29. If... Then...
  30. Solved: Removing the $ sign
  31. [Application.ScreenUpdating = False] but screen still flickers...
  32. Covert File - Run Macro - Save As Excel Workbook
  33. skipping numbers
  34. Write Macro from formulas?
  35. using a cell's text as part of a filepath in another cell
  36. Update Date
  37. Using colors to show numbers
  38. How to design form date, currency?
  39. Macro for adding arrows and textboxes to a graph
  40. autofit shape
  41. add a button to a built in toolbar
  42. Finding a number in a range
  43. Solved: Cascading dropdown list
  44. Solved: Currency symbol in Excel
  45. Counting in a AutoFilter column
  46. Trouble Getting ?ExecuteExcel4Macro? to Work
  47. Auto disconnect shared excel file
  48. Email Individual Worksheet Rather Than Workbook
  49. Click-through tracking from Excel?
  50. USING ADDRESS AND MATCH COMMANDS
  51. working with formula in cell instead of a value
  52. Validation or User form??
  53. Initializing Find
  54. Excel Macro
  55. comparing two macros
  56. Help! I need to modify and existing workbook.
  57. Listing All Criteria with Autofilter
  58. Very new to XL Synchronization
  59. Solved: If problem
  60. Solved: Hyperlinks need to go
  61. Linking to a picture
  62. Solved: problem writing formula via vba
  63. Solved: Find and Copy minimum values to other sheet
  64. Calling function gmtime from system dll fails.
  65. Lookup for Next (not last) Date
  66. Effects of AutoShape on a Chart
  67. change a string in each worksheet
  68. Moving rows using address and match
  69. Pause a Macro
  70. Autofit merged cells
  71. Macro to retrieve data from closed workbook
  72. Chart
  73. Autofit Cells
  74. GCD doesn't handle division well?!
  75. Solved: Select/Unselect all check boxes macro help
  76. select & copy last sheet
  77. Solved: Check if sheet name exists before deletion
  78. column header labels - splitting and merging for layout
  79. Solved: Conditional hiding of rows
  80. Solved: Protection Problems
  81. Solved: Conditional Protection (locking) of a Row
  82. Solved: Running queries in Excel with SQL statements
  83. Solved: Remove a macro after execution?
  84. Solved: Generated Code for Chart ... What Happened?
  85. Excel Send Macro for Groupwise
  86. Addin worksheets
  87. Manipulate data in a separate worksheet
  88. Findnext in open workbooks
  89. similar dates for same value for same period, write in same cell, and remove dups
  90. icon do not show of toolbar
  91. Solved: E-Mail/Command Buttons
  92. Solved: Import a text file into excel delimited
  93. Tab In VBA Excel
  94. TreeView_NodeCheck Event
  95. Protecting area of worksheet
  96. Solved: Help with looping code
  97. Solved: Can rows be hidden/unhidden in spite of sheet protection?
  98. Ignoring a subroutine
  99. Residual value next row
  100. Solved: Setting passwords in Excel to control data access.
  101. Solved: Remove part of the data in a cell
  102. Solved: Grid lines reappear after running macros
  103. Solved: Need help with UserForm RunTime error 1004
  104. Merge two scripts
  105. Handling a Sheet Object in Richtext
  106. update a dynamic range from a combobox
  107. Solved: Copy and Paste with Macros
  108. Macro for copying and pasting data to new worksheets.
  109. return the top occuring values in a list
  110. track changes in word to excel
  111. [SOLVED] Fill formulas to end of column
  112. Solved: Workbook_Open entry
  113. [SOLVED] Add another condition to formula
  114. search and display row on same sheet
  115. Importing and updating "Master" worksheet.
  116. Solved: ThisWorkbook.Path
  117. My ActiveX doesn't work anymore
  118. How to jump between cells
  119. Solved: Naming Worksheets
  120. program to code VBA
  121. Addin Function that doesnt work
  122. Copy to another worksheet
  123. Enum Statement ? What?s It Used For?
  124. How to hide macros or VBA codes
  125. Anyone Help me Turn these formulas into VBA ?
  126. Only 7 IF's -- but thats strange!
  127. Converting military times to numbers
  128. Copying text from cells to empty cells.
  129. Solved: Email a worksheet
  130. Unexplained loss of data while using a query.
  131. Read XSL(T) Files
  132. Save as conflict resolution
  133. 2nd UCase/Target Challenge
  134. Solved: Interpreting Macro Recorder Output
  135. Listbox
  136. Change Save as Keyboard shortcut
  137. Dynamic Ranges Chart VBA
  138. retaining conditional formatting with advanced filter
  139. How does this code work????
  140. Solved: Saving Bitmap from Excel
  141. Do while loop question
  142. copying validation
  143. Visually Detecting Change
  144. Solved: Determining the Active Cell...
  145. Solved: Interaction With Word From Excel
  146. Solved: split function
  147. Solved: Functions LARGE and SMALL, avoiding duplicated values
  148. Solved: Possible Format Bug
  149. Solved: End(xlUp).Row).FillDown formula
  150. Solved: Graph inside a userform
  151. Solved: Locate Imported Files Using VBA??
  152. System Error while opening an Excel file
  153. Need help in generating WordArt in VBA
  154. converting number into words
  155. Add new list items in a listbox
  156. Real user name
  157. using alarm
  158. looping through columns and rows
  159. Solved: Macro alternates fast & slow execution time
  160. Solved: Protect doesn?t work all the way
  161. Ragged Arrays - Safe Arrays
  162. [SOLVED] Dates In VBA
  163. Finding matching rows on two worksheets
  164. Solved: Correct syntax
  165. make directory
  166. 3 big problems: filter listbox w/ dropdown, change cell display by listbox select...
  167. VBA multi column listbox help
  168. Solved: Identify cell which have formula
  169. Solved: Copy last row
  170. Determining Numbers for Chart Statements
  171. Solved: My spreadsheet needs to be violated, I mean validated :)
  172. VBA Code / Formula for salary per dept
  173. date as integer
  174. Count occurrences in a textbox
  175. Insert forms: Size to user defined range
  176. Trouble with QueryTables
  177. Solved: Select vs. Activate
  178. Solved: need little advice on this Formula
  179. Solved: Problems using protect and unprotect in VBA
  180. Solved: Hiding Code
  181. Solved: Help with select case
  182. Solved: date formulas ?
  183. Counting Conditional Formats / Colours
  184. Solved: Code Creating Error
  185. Solved: ComboBox or ListBox Value
  186. Non Mathematica forumlar for creating a list of names
  187. insertion of picture with the help of VBA
  188. Solved: Return Excel Dialogs selections
  189. Solved: Pivot Table problem
  190. Solved: Prevent background color from printing
  191. Solved: VBA Using find Excel 2003
  192. HELP!! Disappearing Cursor during Flash Play
  193. Find Template Path
  194. Solved: Emulate Shift-Ctrl-Alt and F9 Keys..
  195. delete all user made toolbars
  196. Solved: Insert Row Macro/VBA
  197. How to Determine Where I Am on a Worksheet
  198. [SOLVED] Check for folder; create if it does not exist
  199. Solved: Creating a config file.
  200. How to swap text between 2 columns?
  201. strip decimal point but keep cents
  202. intializing a userform
  203. Need help with Excel Macro - InRange??
  204. Linking to a lot of excel files
  205. How Do I Get Commandbar Values?
  206. color index
  207. Solved: Autofilter and apply cell value to visible cells
  208. Solved: Message Box On Open
  209. HyperLink
  210. Solved: Show Userform problem
  211. Solved: Objects move after printing
  212. Solved: Show Dupes In Column A From Position > 200
  213. Excel crashes when using Excel 2003
  214. addbuttonandcode
  215. Solved: VLOOKUP now you see it now you don't!
  216. Hey! Who left that file open?!?!
  217. Help with Excel 'find' please
  218. Only allow Paste Special / Values
  219. Problem Printing
  220. Solved: Selecting a range based on text box entry
  221. Locking Formulas
  222. To Convert Excel to PPT
  223. How can I change the texts in text file?
  224. Solved: Listing Named Ranges and Ranges
  225. Move row based on column criteria
  226. Solved: VLOOKUP
  227. Stop user interaction with VBA
  228. Solved: Import Text problem
  229. 1024 Character Limit Workaround
  230. Solved: A Quick Queston, rows and column index on an activecell
  231. Find och go to cell
  232. Solved: how to autofilter then to paste
  233. Solved: Running VBA in one worksheet to hide rows in another worksheet
  234. Excel Open Outlook, change activeprinter, class
  235. sorting the project explorer
  236. Solved: write a VBA program for me.
  237. Solved: Name a Range
  238. String Range Compare
  239. Solved: BeforeSave Event
  240. Simple VBA request
  241. Weird MATCH bug?
  242. Copy - Do Procedure - Paste
  243. Trying to backup... Sucks.
  244. Solved: Loading a range into a matrix
  245. Solved: Range Expression
  246. Solved: Finding a character in a text string
  247. Text Box list order
  248. ranking a list
  249. Greyed out "Cut", "Copy", "Paste" and "Paste Special" in Excel
  250. Solved: Format Textbox to 19XX