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

  1. Solved: Calling a Function and Resize
  2. Solved: inserting date where cursor located
  3. Solved: how to paste only value since there r some fuction in cells
  4. Working with a text file
  5. Solved: Aligning data labels in a chart
  6. translating math formula into vba
  7. Problems with foreach loop in a modul
  8. Solved: finding MAX number and matching symbol
  9. Solved: xlCellType
  10. Solved: Userform & Class Module Interaction
  11. Solved: ActiveCell.FormulaR1C1 dynamic column
  12. Solved: Reading a .csv File?
  13. Help With automatically reading a column
  14. Sum months plus today
  15. Solved: how does xlMultiply work? and can i paste and multipy in one go?
  16. Delete named Sheets if they exist
  17. Solved: Listening to the active sheet's events from the personal macro
  18. Download from Excel via URLDownloadToFile
  19. Excel 2007 Macro Recorded
  20. Solved: Intersect
  21. Formulas
  22. Playing with arrays... sort of
  23. Conditional locking of row
  24. VBA Error help please
  25. VBA to copy 3 worksheets and email
  26. Excel to Word... little help required
  27. Solved: Macro Recorder Code fails
  28. Can this code be simplified
  29. Solved: Using a Date variable in Excel 2007 macro
  30. Excel Macro Help
  31. Selection
  32. Solved: Clear cell contents without deleting formula
  33. Solved: multiple file selection
  34. VBA for multiple excel file
  35. Extract a list of employees according to month
  36. Solved: Probably a quick solution to this! - finding rows
  37. Solved: Delimiting in odd situations...
  38. Solved: Excel VBA
  39. Write a value from a cell formula
  40. Solved: Why is this code simply exiting without reason?
  41. Use of Ajax in an inputbox?
  42. Solved: Hide unhide rows in range
  43. Set StartCell as ActiveCell
  44. Solved: Formula to allocate absolute values
  45. Solved: How to export bookmarks from word to excel
  46. VBA Code Problems with Sending Excel DB through Outlook
  47. Sorting While in .FilterMode
  48. adding up interchanging word in a single cell
  49. Split The Column Data based on first column values using VBA
  50. Solved: How do you clear filter in macro?
  51. Solved: XY chart with values on top of each other
  52. use combobox as history
  53. vba MultiSelect ListBox based on advanced filter
  54. Divide the Column Data using VBA
  55. Solved: Change cell colour if changes made
  56. Multi Select List Box based on Advanced Filter
  57. Solved: Add 1 when copying and linking.
  58. Solved: Error Handling
  59. Help with Syntax Using ADO to Query Excel Worksheet
  60. Solved: Football Team Record Ranking
  61. Solved: Detecting Conditional Formatting
  62. Solved: Removing certain string
  63. Solved: Date as an Index
  64. Executing Macro at Time with Excel Closed
  65. Search Function in a User Form
  66. Solved: Selecting a Range of Rows
  67. Solved: using name in VBA propertys vs Sheet name
  68. Solved: How to create Yes or No Message Box?
  69. Extract a string from a cell
  70. Is this a timeout issue?
  71. Grabbing Data..Excel VBA
  72. Solved: VLOOKUP the Nth Occurance
  73. Solved: Use Vlookup in VBA Code
  74. Excel 2007 macro for comparing multiple dates
  75. Solved: could not set the value property. Invalid property value
  76. Combo Box / List box help
  77. Stop dialog box popping up
  78. Solved: Hlookup and Vlookup problem
  79. Solved: Filter from Drop Down Box
  80. how to change multiple value instead of one value at a time?
  81. VBA Code to know the date of creating a new worksheet
  82. lookup function in VBA
  83. Solved: Events
  84. Need macro to list folder with name and size in excel. Thanks
  85. User form will not allow blank fields
  86. Solved: index/match
  87. Copy & Paste Dates with Macro
  88. Solved: Worksheet Change Event
  89. Solved: Uncheck CheckBoxes if one is checked
  90. Tool or editor require for understanding return value of each argument of so many nes
  91. Month selection
  92. Set trial period for use of your project
  93. ِAccepting new repeated entries or not
  94. Solved: Avoiding errors in formulas
  95. Problem: ClassFactory cannot supply requested class
  96. Confused About Run-time error '1004': Application-defined or object-defined error
  97. Capturing UNDO Stack
  98. con.open error message data source name not found no default driver specified
  99. coloring similar cells in values in the same column
  100. Create school timetable by vba
  101. Copy contents from various excel files in a folder and merge
  102. Sum of Cells Within the Selected Range (vba)
  103. Solved: 1004 error
  104. Open and copy/paste data to same row...
  105. Solved: SUM(IF with an OR statement produces incorrect results.
  106. Solved: auto run the macro
  107. Solved: VLOOKUP Question
  108. Solved: Count an array of data based on Sum
  109. Solved: Putting a slash between numbers and text
  110. Solved: Get data(Zipcodes) from web page and paste to excel
  111. Copy row to the duplicate row - Macro
  112. Exchange (part of) file name with a cell ref in Vlookup formula?
  113. combobox generate another combobox
  114. Solved: Changing default weekday
  115. Solved: vba vlookup fix
  116. Bookmark Runtime Errors, 5941 and 462
  117. How to compare two same files
  118. combobox generate another combobox
  119. Charting Scenarios
  120. Dynamically creating variables...possible?
  121. Find and Replace Dynamic values
  122. VBA help: need to transfer 130 cells to memory and back
  123. Printing specific records
  124. how do we access a variable declared in one form to another form
  125. Adding a blank string in between
  126. Worksheet event code to copy Formula
  127. Solved: Unmerge target cell
  128. Solved: converting multi-dimension array to single-dimension
  129. How to import XML to excel without the HTML, I think?
  130. Solved: Write to Word from Excel
  131. Solved: Sum an array of data when records are > $xxx
  132. Range References in VBA when Wks Rows/Columns Deleted
  133. Solved: Run-time Error 70 creating application object in Windows 7
  134. transpose macro
  135. Pivot Table
  136. Copy specific multiple groups of sheets to new workbooks
  137. Solved: find first item in column
  138. align input data
  139. Random Sampler Macro
  140. Finding the min or max value in a sub range of a reference.
  141. Solved: SEARCH COLUMN FOR VALUE AND COPY ROW
  142. Solved: Macro to find specified date in a range
  143. How to delete external links excel 2007
  144. Solved: Deleting duplicate data
  145. Defining an array as a range of cells
  146. hyperlink
  147. Solved: Error Setting Selection.Formula in a ListColumn
  148. Solved: extend the border line until desired row
  149. Control on Combobox
  150. Solved: represent column by variable
  151. Problem with UDF Function
  152. Run time error '6'
  153. Update links between workbooks
  154. Find row based on picture
  155. Classes
  156. Need help replacing For Next Loop with AutoFilter
  157. VBA OOp
  158. Assort information in columns from rows
  159. Solved: Deleting Defined Names
  160. Install a new font in Excel
  161. mail item problem
  162. Force enabling macro
  163. Solved: Separating between each two digits
  164. @Wierd Calculation Issue - VBA- Excel (2007)
  165. DTPicker
  166. Changing dates in a cell
  167. Solved: Copy 2 cells with formula.
  168. [SOLVED] Saving a chart to .pdf
  169. Solved: is there any way i can change the WB created date
  170. add item to a listbox
  171. Solved: Total distance and time between two cities in a state
  172. vblf's peculiarities
  173. using vba to copy and paste from a website
  174. Solved: copying value set to variable
  175. Solved: Defining a variable number of arrays?
  176. How to highlight conditional formatting
  177. Listen to double click
  178. Save file as TXT or CSV
  179. Create New tab
  180. Greate ChartLines & Show SeriesPoint(i)Values?
  181. Formula help
  182. how to stop at the last row
  183. Unviewable projects
  184. Sending Excel range to Access; question...
  185. random
  186. Add 1250 textboxes in excel using vba vb6
  187. Get entire worksheet range
  188. Copying a row in Excel using VBA
  189. Solved: Creating a number of workbooks
  190. Solved: Compare Column Data
  191. Transparent Command Button Covers Text
  192. Working with Cell Comments
  193. Solved: Horizontal Sorting
  194. Array Formula
  195. VBA Application to print multiple, user selected files
  196. VBA Function Help
  197. Set Chart Height and Width to Match Page Dimensions
  198. Spedometer Type Chart (Donut) - Help with Formula
  199. Solved: Add from Month of April Onward
  200. Set Properties for Printing
  201. Run a macro at a specific time and day
  202. Formulas help
  203. Messy alignment when copying to Power Point
  204. Unique items in ListBox
  205. Solved: correction
  206. Solved: Producing Error
  207. Compare one workbook with multiple workbooks
  208. Solved: data from txt to existing sheet (only fix my code)
  209. Solved: Select Case
  210. Excel 2007 error with code for creating passwords
  211. Excel Date Problem (XLD!!!)
  212. I expect this is fairly simple...
  213. Automatic Sort On double Click
  214. 2D arrays
  215. Ribbon Object in xl2007 vs CommandBar Object in xl2003
  216. Creating a UserForm Programatically, with Frame
  217. Excel 2007 Unlocking Specific Cells Based on Password
  218. combox transfers data
  219. Solved: Replace carriage return and line feed in excel
  220. Solved: Checkboxes form Form Controls
  221. Need help with some VBA - Probably very simple
  222. Solved: zoom sheet on background
  223. Microsoft listview control 6.0 (SP4) problem
  224. Solved: How to raise/lower the Windows Taskbar with code
  225. Conditionally hide and unhide cell ranges
  226. Solved: Dynamically determine week number and filter
  227. Excell 2007 - select all/copy
  228. What Are the Black Dots For On Excel Worksheet?
  229. Solved: Importing Data from Multiple Worksheets
  230. Filter Fails to Work - Incorrect Format?
  231. copying chart from one workbook to another using VB
  232. Need help with combobox
  233. Solved: Copying data from excel to word
  234. VBA Code to Delete Rows with AWR
  235. Detect changes to VBA code.
  236. UDF Function to refer to the Sheet Name
  237. Write this formula in a shorter way
  238. Reference to different VBAProject
  239. Excel VBA for multiple email on button
  240. VBA: Go Down Page & Add Seperator Lines
  241. Need help with word to excel function
  242. filtering cells based on data in listbox
  243. Data Validation List with no empty cells
  244. Limit cell to numeric values only
  245. Training Educational DVDs for VBA on excel
  246. VBA Dynamically Saving in a Folder Structure
  247. how to search all w sh in WB
  248. Solved: Application or object defined error
  249. VBA Code if a user input in an inputbox causes error in a running macro
  250. VBA Not working in Office XP