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. Solved: Running two macros on opening
  2. Hint about VBA functions
  3. How to dyamically change which pages will print
  4. Solved: Data Validation on User Form
  5. ComboBox Help!
  6. Sleeper: Excel to Autocad
  7. Loop through charts
  8. Resetting Color Pallette
  9. Seeking help in creating an excel macro for shutting down pc
  10. Find the cursor position in a string
  11. Coloring depending on the Series
  12. Excel Crash
  13. Solved: Checking if macro run again- same month
  14. How to access menu items of Excel add-in?
  15. [SOLVED:] Lookup question
  16. Solved: Adding pre-fixes
  17. Stop code from running when opening
  18. Inter related items
  19. Solved: Applying an Advanced Filter Using VBA
  20. Macros for excel
  21. Create a List based on Cell Values from multiple Sheets & Columns
  22. VBA Code to export formula to cells?
  23. Loop trough workbooks and Paste values
  24. Solved: Sort Not Working When Formatting Applied
  25. Sumif formula
  26. Solved: Displa first item in combo box
  27. Solved: Make Code run only on xls files
  28. Excel - transpose multiple records
  29. [SLEEPER:] VBA Column Looping
  30. Solved: error when looping
  31. Autofilter on row 3
  32. Speeding Up Vlookups
  33. Solved: Option Explicit
  34. Help in sorting in data or macro or simple method.
  35. Write to Module Using VBA
  36. Extending chart series range
  37. Solved: SUMIFS
  38. copy down formula
  39. Merging Cells
  40. Dynamically Specifying Series and X/Y Values of a Chart
  41. Excel Custom Headers and Footer
  42. Converting formula into values.
  43. How to control which vba Excel program has control on computer
  44. Populating Oracle SQL Queries in different Sheets in Excel using VBA code
  45. Webbrowser control
  46. Solved: text box dependent on list box in userform
  47. Solved: ignore files which are blank?
  48. Excel File Properties in Windows Explorer
  49. Macro to countif multiple criteria
  50. Exporting Data into Different Cells at Set Intervals
  51. Solved: other possibilities?
  52. VBA: Identify Last Column with data in a specific Range and copy to next column
  53. unable to set the text property of the characters class
  54. Solved: FindNext
  55. Sending the Email by Excel by searching the Attachment names start with 302568
  56. Bring chart infront of web browser
  57. Import txt files into excel
  58. Solved: insert text in columns with itineration
  59. Solved: Run a macro with inputbox
  60. Solved: Determining size of chart area?
  61. camembert
  62. [SOLVED:] Trigger Macro by change in formula value within a cell
  63. Solved: label.caption take text from file
  64. [SOLVED:] Userform + Range=#value
  65. Staff ID Number format
  66. Solved: Macro processes too much, so Office apps hang until finished! Ideas?
  67. Spin Button
  68. How to Make Handwritten Code or Macros
  69. Solved: Week Number Of The Month
  70. Solved: UDF in Conditional Formating
  71. Interesting Issue With Labeling Data Points
  72. AfterUpdate Event
  73. Solved: Age calculation
  74. Solved: MkDir, multiple directories?
  75. Solved: Animation Control limitations
  76. Enable Macros when opening Worksheet
  77. Solved: Adding text to a cell with CheckBoxes
  78. Solved: Conditional Formatting
  79. Interacting the Search Dialogue Box
  80. Solved: Create on the fly labels with click events
  81. Solved: Comparing two columns of data and outputting the differences
  82. Solved: Arrays with Arrays
  83. Problems with interface design for when long macros process (suggestions welcome!)
  84. Adding to Named Range and Disappearing coloring
  85. Solved: Ending a loop at the bottom of column
  86. Solved: Calculating stock price volatility over and over and over...
  87. Solved: VB code to save file to app directory?
  88. Code to save to a sub folder?
  89. [SLEEPER:] Picking respective value from different col based on a particular value input.
  90. [SOLVED:] Show Desktop
  91. Solved: Counting Text with commas
  92. Imported dates
  93. C&P format & formula if certain data entered
  94. Solved: Code to stop all subsequent code and return to userform
  95. Set max value in array item?
  96. How to paste in selected rows of the selected column
  97. Solved: Finding Bad Names
  98. Solved: Data input macro help needed
  99. Plugging time in excel sheet
  100. Report Based on following sample of data
  101. Solved: VeryHiding Sheets after given date
  102. Unhide Hidden Rows
  103. SUMIF IN VBA with external references
  104. VBA - answer "yes" or "no"
  105. Mapping Values
  106. [SOLVED:] Circular reference in a formula
  107. How to create a UDF Function?
  108. Referring to an array in many subs
  109. excel formula in vba
  110. Solved: One variable defined as text, the other as integer Problem
  111. Solved: Nested IF function
  112. Restrict Worksheet Scrolling Help
  113. Solved: Question About Circular References
  114. Solved: How to calculate running totals
  115. Sleeper: Invalid references table and copy the valids to another table
  116. Solved: Managing the Case of First Letter
  117. Excel 2000 vs 2003; additional control; substitute
  118. Solved: Macro to sort data ascending
  119. Solved: Keep selected cell centred
  120. Solved: Inserting dynamic range into new table
  121. Solved: (location) inside of the combobox
  122. Solved: Debugging a VBA programm in Visual Basic Editor (VBA Excel )
  123. Solved: FILE DATE
  124. Solved: Finding Matching Date
  125. Solved: Sort Data Based on Value of a Cell
  126. Combining multiple worksheets WITHOUT the same arrangement.
  127. Solved: How modify VBA to split multiple cell?
  128. Solved: Calculating Hours Earned
  129. Create userForm by code
  130. [SOLVED:] Listing file/folder attributes from user input
  131. Solved: VLOOKUP in multiple arrays
  132. Autofilter, copy-paste to new sheet
  133. Solved: Problems with running pre-Excel 2007 macros
  134. [SOLVED:] Adding values
  135. Solved: Help With a Formula
  136. Display percent value
  137. Solved: QueryTable wont work in Excel 2007
  138. Solved: Move columns
  139. VBA Macro for Log File
  140. Solved: Calculating Hours Earned
  141. Solved: translate from Excel in VBA
  142. Instant messenger in EXCEL
  143. INDIRECT VLOOKUP formula problem
  144. mark duplicate row with condition
  145. Solved: Formula Problem
  146. Solved: DELETE LAST
  147. Solved: moltyply times
  148. Center userform using Printform
  149. Column to headings& heading contents to rows
  150. Solved: Populating a userform....
  151. [SOLVED:] Please Help with Checkbox Alternative
  152. Solved: Copy Sheets to new workbook and save copy
  153. display label as Year & text
  154. Solved: How to assign different face id to macros in a toolbar
  155. Solved: Misserable example....
  156. Solved: Convert time entered on row to ascending dates
  157. loop
  158. pivot table question
  159. Book Recommendation
  160. Sleeper: Get Combobox2 value if a value is selected in combobox1 in the WorkSheet
  161. [SOLVED:] Make Selection on sheet1 that will duplicate on all worksheets
  162. A macro code to check whether any workbook is currently open or not.
  163. Copy Colours
  164. Solved: Date Delete
  165. How to alter Paste Range in VBA
  166. copy transpose
  167. A macro to authorize a user to run another macro.
  168. Extract GPS data from jpeg file properties with VBA?
  169. Solved: How to create a VBA program based on lookup formula
  170. Solved: the number in this cell is formatted as text
  171. Text Format need help
  172. Strange things happening
  173. How to copy only the headers and columns of requested
  174. Calculating 99% in entire cell in Col M. Col M is filtered
  175. Solved: Restrict Saving WorkBook
  176. delete
  177. Holiday and earned time minor problem
  178. windows services in Excel VBA
  179. Solved: Extract data from Website to Excel
  180. How to get this formula shorter
  181. open multiple workbooks and enable macros, then close
  182. Solved: Checkbox control(s)........looping
  183. Paste Especial/Value/Transpose . . .
  184. Take the size of the Array
  185. VBA Date Range Argument
  186. [SOLVED:] Need macro to remove text
  187. Solved: Copy Worksheets from one Workbook to Another
  188. Sleeper: VBA code needed for creating references in Excel
  189. Need a code to place Excel charts to Powerpoint (Different Sizes)
  190. create list of references
  191. Partial format of cell
  192. Identify the write mode of a workbook
  193. uneditable comboboxes
  194. Solved: trim function.
  195. Using a defined string in a vlookup
  196. Solved: Change Values
  197. Extract from worksheet into new workbook, for daily reporting.
  198. Solved: Outputting Listbox values AND filtering using those values
  199. Solved: DOUBLE LOOKUP HELP
  200. Splitting summary sheet based on workorder ColA.
  201. Solved: Save As dialog help.......please!
  202. complicated Match
  203. Solved: Populate ListBox with Multiple Rows of Data
  204. Solved: Excel Scatter Graph Horizontal Line
  205. Solved: How to design a code based on excel formula?
  206. Rearrangement of Code & Immediate Windows!
  207. Solved: Email file with password HELP please
  208. Solved: Looping named cells
  209. Solved: FileSearch VBA
  210. Solved: Search all worksheets
  211. Solved: Add another sheet to the search
  212. Arrange sheet data
  213. Lookup from external text file
  214. Multiconditional sort, match and list with exceptions
  215. [SLEEPER:] Populate ComboBox with contents of ListBox
  216. Dynamicly Fill Listbox with column headers?
  217. Solved: Import of csv file fails in 2007 only
  218. Solved: Rearranging columns
  219. Solved: A simple formula would probably do the trick
  220. Copy Data From Orders to Database
  221. Solved: MsgBox - Error
  222. Skipping the Browse For Folder
  223. Solved: Clear cell not entire row
  224. Solved: Class module for two-dimensional array
  225. Solved: Filter worksheet using List Box (multi select) Selections
  226. Nice image import code
  227. Solved: Multiple Column Colour Change
  228. Searching folders
  229. Solved: Reverse find
  230. Solved: Lookup Values Across Tabs and Set Flag
  231. Copy and paste data based on criteria
  232. Solved: Range Copy to different worksheets
  233. Solved: What's wrong with my copy/paste VBA code
  234. [SLEEPER:] Groupwise VBA to Change "From" field
  235. [SLEEPER:] Email files with same names from folder
  236. Solved: Macro "Stautsbar" from ThisWorkbook i want for whole excel
  237. Solved: Date Problem In Chart
  238. Solved: How to stop nuisance warnings
  239. Terminate Excel Process
  240. Cell Format Number Issue
  241. Solved: dual purpose TextBox string
  242. Paste data in clipboard
  243. Solved: Binding Macros to Buttons
  244. Trial Code Error
  245. can't get caluclate event to fire vba
  246. Search and Replace Macro
  247. User form OHR and Password break.
  248. macro search
  249. Lookup value in Table
  250. Extract data from MS Access table using excel macro.